Ninjakreborn Posted September 10, 2012 Share Posted September 10, 2012 SELECT title,dateFrom From tbl_event WHERE (`dateFrom` = CURDATE()) OR (`dateFrom` > DATE_ADD(CURDATE(), INTERVAL -2 DAY)AND `dateFrom` < CURDATE()) order by dateFrom asc LIMIT 0,4 I just want to see if there were any results today, or yesterday. That's pretty much it. The above code seems to be off, any advice is appreciated. Quote Link to comment Share on other sites More sharing options...
Jessica Posted September 10, 2012 Share Posted September 10, 2012 Try using DATEDIFF Quote Link to comment Share on other sites More sharing options...
Psycho Posted September 10, 2012 Share Posted September 10, 2012 No need to have an OR clause to pull records from today OR yesterday. Just create a value for the records starting yesterday and do a greater than comparison. However, your code is going TWO days back. So, you are getting everything from today, yesterday and the prior day. This should work SELECT title, date From From tbl_event WHERE `dateFrom` >= DATE_SUB(CURDATE(), INTERVAL 1 DAY) This will get all the values from today and yesterday 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.