select by date

[adzie]

Hello folks,

 

I want to be able to select information from my table by date

 

so i want to select where the date field is todays date

[envexlabs]

$today = date('YOUR DATE FORMAT');

 

$select = mysql_query("SELECT * FROM `table` WHERE `date` = '$date'");

[The Little Guy]

It all depends on how you have your date field set up in the database, but if you have it set up using one of mysql dates, you could use one of these:

 

 

$select = mysql_query("SELECT * FROM `table` WHERE `date` = CURDATE()");
$select = mysql_query("SELECT * FROM `table` WHERE `date` = NOW()");
$select = mysql_query("SELECT * FROM `table` WHERE `date` = DATE_FORMAT(date,format)");

[adzie]

thanks chaps, yes its a datetime field