CODEWITHSUNDEEP
phpmysqldatecomparison
regxcode
regxcode

Reputation: 423

Check if database table column value is greater than or equal to the current date

How can I comparison date as dd/mm/YY. I want to get data from db greater than or equal the current date ; Code like this

$current_date = date("d/m/Y");
mysql_query("SELECT * FROM pages WHERE date>='".current_date."'");

But it doesn't work?

Upvotes: 0

Views: 121

Answers (1)

Tyranron
Tyranron

Reputation: 608

Don't use php time in MySQL if there is no serious reasons for it. In your situation the best way is SELECT * FROM pages WHERE date>=NOW()

Upvotes: 1

Related Questions