problems in WHERE statment
| From: | Mike Ryan | Date: | Mon, 21 May 2007 19:46:02 +0000 |
| Subject: | problems in WHERE statment | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-255434@lists.php.net to get a copy of this message | ||
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.