Posted by mcyi2mr3@lycos.co.uk on 11/16/05 00:30

Hi all!

Can anyone tell me how i can query my mysql table date format collumn
so that i can retrieve all records where the date has passed
$currentdate?

I hope its something simple like
$datequery ="SELECT date FROM tblrecords WHERE date < '$currentdate' ";

thanks

Marc

• Next in forum: Re: querying a date collumn in mysql
• Prev in forum: Re: How to tell PHP to write data to another frame
• Thread view: querying a date collumn in mysql

[Reply to this message]