mysql> select * from ledaren;
+----+--------+----------+----------+------------+
| id | active | subject | text | pub_datum |
+----+--------+----------+----------+------------+
| 1 | yes | sdlfgsdj | sdlfgsdj | 2007-05-03 |
| 2 | yes | sdlfgsdj | sdlfgsdj | 2007-05-07 |
| 3 | yes | sdlfgsdj | sdlfgsdj | 2007-05-01 |
| 4 | yes | sdlfgsdj | sdlfgsdj | 2007-05-02 |
+----+--------+----------+----------+------------+
4 rows in set (0.00 sec)
mysql>
1.If i with this want to show the oldest message?
2.If i with this want to show todays message?
3.If i with this want to show the newest message but not the one in curdate()+1 or more? (maybe i got it there :)
4.If i with this want to show the message closest to pub_date