1internet Posted February 17, 2013 Share Posted February 17, 2013 So I want to run a set of results, fetching rows that have a date that is higher than the current date today. There is a column called date, so this will be checked for each row against the current date. Something like "SELECT * FROM `test` WHERE '$date' > $currentDate" How is this done? i.e. I don't want to show rows that have expired. Quote Link to comment Share on other sites More sharing options...
Barand Posted February 17, 2013 Share Posted February 17, 2013 "SELECT * FROM `test` WHERE date > CURDATE()" 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.