dbradbury

i got it working i sued CURDATE() in my query with plain less than(<) and greater than (>), but no i think the timezone is set wrong.. how would i change this?? i need it to me GMT, thanks in advanced

i meant $getbookings = mysql_query("SELECT * FROM phpbb_posts WHERE forum_id=17 AND post_subject < CURDATE() ORDER BY post_subject ASC");

done i used CURDATE() so it was: $getbookings = mysql_query("SELECT * FROM phpbb_posts WHERE forum_id=17 AND post_subject <= '$date' ORDER BY post_subject ASC");

done i used CURDATE() so it was: $getbookings = mysql_query("SELECT * FROM phpbb_posts WHERE forum_id=17 AND post_subject <= '$date' ORDER BY post_subject ASC");

i need to select all posts in a forum that were posted previous to 'todays date' <- obviously changing daily.... note that the subject of the posts will be date format of YYYY/MM/DD (Y/m/d) i have something like $getbookings = mysql_query("SELECT * FROM phpbb_posts WHERE forum_id=17 AND post_subject <= '$date' ORDER BY post_subject ASC"); but think i need to add a date variable declaring todays date..?

thanks for you help would i need to set $date to todays date? $date = date('Y/m/d') NOW(); or something?

if so how would they be used in a mysql query?

i tried > and < but would work very well.. include("connect.php"); $getbookings = mysql_query("SELECT * FROM phpbb_posts WHERE forum_id='17' ORDER BY post_subject ASC AND post_subject > $date"); just so you know.. that post subjects are dates formatted YYYY/MM/DD.. so they can be sorted. and i would like this code to select a the ones that are greater than or less than todays date.. can someone help me please? thanks