PDA

View Full Version : Return results from before todays date.


lux
04-22-2006, 04:18 PM
I wish to create to recordsets;

One which returns all rows from before today’s date and a second that returns any results from today.

Any help would be much appreciated.

lux
04-22-2006, 04:19 PM
Sorry, im using php, forgot to say!

davidj
04-24-2006, 08:23 AM
select * from table where date_field < curdate()

select * from table where date_field = curdate()

lux
04-25-2006, 02:31 PM
cool cool

thanks for the responce