Sorting a database by

[Anon]

Hi, I have an events database which has stored the event in this format:
0000-00-00 00:00:00

ie year-month-day hour:mins:secs

I would like to select todays date and display the next eg 10 upcoming events from this day onward...

I cant use the id field as that gets allocated as each event gets inserted.

I would assume the key would be a clever sql statement and thats all, but Im not sure???

If someone could construct a sql select for me Id be grateful:

My fields are
id
username
stamp
subject
description

Thanks

[Anon]

SELECT * FROM ccalendar LIMIT 30 WHERE STAMP = ' ' ORDER BY STAMP

WOULD THIS DO IT??!!

[Anon]

okay ive answered my own question:

SELECT * FROM ccalendar HAVING STAMP > '2001-10-16 00:00:00'

mysql is great!