query error in php

[dansk]

i got this query in php

$result=mysql_query("SELECT * FROM Announ.jan WHERE Key =' " .date('d'). " '    ")or die(mysql_error());


and i get this error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Key =' 12 '' at line 1

[ted_chou12]

by this: date('d') do you mean date['d']?

[redbullmarky]

ted, in this case, it seems the original use of date (ie, the function) is correct.

i believe "Key" is a reserved word. You should try and avoid using SQL reserved words, but if you want to carry on in this case, enclose the 'Key' with backticks (` - normally the key directly to the left of the number 1).

Also, remove the spaces between the single and double quote:

[code]
<?php
$result=mysql_query("SELECT * FROM Announ.jan WHERE `Key` = '" .date('d'). "'") or die(mysql_error());
?>
[/code]

that should help
cheers

[dansk]

no, I am actually using the date funtion in php

date("d") would return 12 becuase today's date is jan 12

thanks

[dansk]

wow, thanks redbullmarky
i never thought of that

thanks everyone

[ted_chou12]

i c.