MySQL Forums
Forum List  »  PHP

Date ranges problem...
Posted by: andrea orlandini
Date: October 12, 2009 11:56AM


I have to manage a table describing different legs for a travel.
I have a table with Leg_start_date and Leg_end_date date fields.
I have to determine which leg is the current leg for today.

I have tryed the following but didn't work....
("SELECT * FROM legs WHERE legstart <= date("Y/m/d") AND legend >= date("Y/m/d") ")

Any suggestion????


Options: ReplyQuote

Written By
Date ranges problem...
October 12, 2009 11:56AM
October 14, 2009 06:43PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.