Another query problem.

[pullez]

Hi there:
Can somebody help me and point me why this piece of mysql nsert code is not working.

$query="INSERT INTO hotels ( location_ID , description , thumb_url , rate , facilities ) VALUES (' $location_list', '$hotel_field' , '$thumb_field' , ' $rate_field ',\"$ser_data\") WHERE (Name_ID = '$name_field') ";

returning the following error:
MySQL Error:
1064 (You have an error in your SQL syntax near 'WHERE Name_ID = 'name_field') ' at line 1).
Thnks in advc,
Jorge

[Anon]

You're adding a new record with an INSERT statement so you don't want to include a WHERE clause. If you want to update the information use an UPDATE statement and then the WHERE clause will work

[pullez]

Hi Dave:
Thanks a lot, It was a typical stupid newbie mistake.
Regards.