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 `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 [EMAIL PROTECTED] [EMAIL PROTECTED] -- "Religion, ideology, resources, land, spite, love or "just because"... No matter how pathetic the reason, it's enough to start a war. "
pgpBld9Ikeqgh.pgp
Description: PGP signature
