date

[coolphpdude]

hi there,

 

I need help with formatting a search query. I have a database of memo's for a user, each memo has an expiry date, i only want to display the memo's to the user that have not yet expired. so for example I have a memo that is no use past the 20th of june so i set the expirary date in the database to 2008-06-20. This memo will be shown until and including the the 20th of june. Come the 21st of June that memo will no longer be displayed. how do i include that in my search query???

 

so far ive got this,

 

$memo_result = mysql_query("SELECT * FROM memos WHERE username='$user'", $db);

 

This works and all memos are displayed but i need to add something along the lines of:-

 

$memo_result = mysql_query("SELECT * FROM memos WHERE username='$user' AND curdate <= 'expirary_date'", $db);

 

Can anyone help?

 

[RMcLeod]

Something along the lines of

 

$today = date('Y-m-d');
$memo_query = "SELECT * FROM memos WHERE username='$user' AND expiry_date >= '$today'";
$memo_result = mysql_query($memo_query, $db) or die (mysql_error());

[coolphpdude]

thanks alot! that works a treat!!!