mysql date operation problem??

PHPycho · #1 (**permalink**) 01-15-07, 05:29

I am trying to display all the news which are up to todays date. I have used following query but didnt get the success

PHP Code:


			
$sql = "SELECT * FROM news WHERE news_date < = todays_date";

May be i have not enough knowledge about date operation in mysql. What i want is just your help .
Thanks a lot.

r937 · #2 (**permalink**) 01-15-07, 07:28

dunno where you coulda got "todays_date" from

try CURRENT_DATE which is the standard sql function (and also works in mysql)