dadamssg Posted March 1, 2009 Share Posted March 1, 2009 my use of NOW() isn't pulling up what i want it to...i have start and end times in each row of data so i want to pull up rows that haven't ended, but this is working.... SELECT * FROM `test` WHERE end >= NOW() it pulls up like 3 out of 10 and i can't figure out how the heck to use NOW() so it pulls up all of them....FRUSTRATING Link to comment https://forums.phpfreaks.com/topic/147376-correct-use-of-now/ Share on other sites More sharing options...
corbin Posted March 1, 2009 Share Posted March 1, 2009 What kind of field is end? That should work fine. Link to comment https://forums.phpfreaks.com/topic/147376-correct-use-of-now/#findComment-773642 Share on other sites More sharing options...
dadamssg Posted March 1, 2009 Author Share Posted March 1, 2009 its a datetime...i have no idea why it isn't working like it should...it pulls up events that don't end for like months, but if it ends the same day as today..won't pull it up Link to comment https://forums.phpfreaks.com/topic/147376-correct-use-of-now/#findComment-773647 Share on other sites More sharing options...
fenway Posted March 1, 2009 Share Posted March 1, 2009 Show table structure, sample data, etc. Link to comment https://forums.phpfreaks.com/topic/147376-correct-use-of-now/#findComment-773705 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.