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 Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted March 1, 2009 Share Posted March 1, 2009 Show table structure, sample data, etc. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.