[SOLVED] Help on Array Please

[BrianM]

Here is my code:

<?php
$result = mysql_query("SELECT Date FROM $table id=$id") or die(mysql_error());
?>

 

And here is the error I'm receiving:

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 '08-1111-E id=1' at line 1

 

Can anyone tell me what is wrong?

 

Thanks

[trq]

Date is a special word in sql, either change your field name, or surround it in `backticks`.

[trq]

Hmmm, your also missing your WHERE clause.

 

<?php
$result = mysql_query("SELECT `Date` FROM $table WHERE id=$id") or die(mysql_error());
?>

[BrianM]

thorpe, thanks very much.  You are right.  It now works.