What's wrong with this mysql query?

Databases
1 
$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

:rolleyes:

2

UPDATE is a reserved word

:slight_smile:

3

oh :slight_smile:

Thank you :wink:

4

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

5

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

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

:slight_smile: