Re: problems in WHERE statment
| From: | Eric Butera | Date: | Wed, 23 May 2007 17:28:03 +0000 |
| Subject: | Re: problems in WHERE statment | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-255446@lists.php.net to get a copy of this message | ||
On 5/21/07, Mike Ryan <miker@mail.manti.com> wrote:
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
Single quotes in PHP do not evaluate their contents. Double quotes
do. So $today is literally $today instead of the value you set in it.
$hi = "Hi";
echo '$hi';
output: $hi
echo "$hi";
output: Hi