How to return from 'todays' date?

[Plogu101]

Just a little problem, this query is working..nearly... I just need it to return starting from the first instance of todays date, in the table? If anyone can help you'd be a lifesaver....

"SELECT * FROM Aberystwyth ORDER BY Date, Time LIMIT 20 ";

example:

"SELECT * FROM Aberystwyth (starting from todays date here?) ORDER BY Date, Time LIMIT 20 ";

 

[sleipnir214]

WHERE date > now()

?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[hoinz]

to get descending order:
... order by date desc, time desc ...

Is this what you are looking for?