< > these exist in php?

[dbradbury]

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

[Pikachu2000]

PHP and SQL syntax really have nothing to do with each other, however they are used in a SQL query the same as they are in php. What's the problem?

[dbradbury]

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..?

[dbradbury]

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");