brown2005 Posted September 20, 2007 Share Posted September 20, 2007 i have two fields start end what i want to do is from todays date select from start - end Link to comment https://forums.phpfreaks.com/topic/70032-date-between/ Share on other sites More sharing options...
Jessica Posted September 20, 2007 Share Posted September 20, 2007 Way too vague. Do you want a dropdown with all of those options? What do you mean select? Are you talking about a database? we're not mindreaders, cmon. Link to comment https://forums.phpfreaks.com/topic/70032-date-between/#findComment-351704 Share on other sites More sharing options...
brown2005 Posted September 20, 2007 Author Share Posted September 20, 2007 in the sql i want to say date is between start and end like that Link to comment https://forums.phpfreaks.com/topic/70032-date-between/#findComment-351717 Share on other sites More sharing options...
Jessica Posted September 20, 2007 Share Posted September 20, 2007 What field type are they? int, date, datetime? Link to comment https://forums.phpfreaks.com/topic/70032-date-between/#findComment-351718 Share on other sites More sharing options...
brown2005 Posted September 20, 2007 Author Share Posted September 20, 2007 date mate... Link to comment https://forums.phpfreaks.com/topic/70032-date-between/#findComment-351720 Share on other sites More sharing options...
Jessica Posted September 20, 2007 Share Posted September 20, 2007 $sql = "SELECT * FROM table WHERE date > $start && date < $end" Link to comment https://forums.phpfreaks.com/topic/70032-date-between/#findComment-351725 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.