I am a newbie so please bear with me. I get this error message when I try to run a query Connected successfullyCould not successfully run query () from DB: Unknown column '$today' in 'where clause' this is the query command $query = 'SELECT * FROM `job listing` WHERE open >=$today LIMIT 0 , 30 '; I have assigned $today this way $today=date("Y-m-d"); Can you tell me what I did wrong?? thanks for your help. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php