Re: problems in WHERE statment
| From: | Davi | Date: | Wed, 23 May 2007 17:24:24 +0000 |
| Subject: | Re: problems in WHERE statment | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-255442@lists.php.net to get a copy of this message | ||
Em Segunda 21 Maio 2007 16:46, Mike Ryan escreveu:
> 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
Attachment: [application/pgp-signature]
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??
>
Sure! =)
You must scape your PHP variables in any SQL query...
Try this:
$query="SELECT *
FROM joblisting
WHERE open >= '$today'
LIMIT 0,30";
HTH
--
Davi Vidal
davividal@siscompar.com.br
davividal@gmail.com
--
"Religion, ideology, resources, land,
spite, love or "just because"...
No matter how pathetic the reason,
it's enough to start a war. "
Attachment: [application/pgp-signature]