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