What's wrong with this mysql query?

$query="SELECT * FROM people WHERE (name='$display_names[$x]' and address='$fulladdress4db' and update='$update[$x]')";

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 ‘update=‘08/2009’)’ at line 1


UPDATE is a reserved word


oh :slight_smile:

Thank you :wink:

btw r937, i think now i need to rename my database ‘update’ field :rolleyes:

yes, you need to rename your table’s update column :wink:

you can do this with the ALTER TABLE statement’s CHANGE COLUMN option