I want to change the values of a record in the database. Here is what I am using, what do I need to change?
"INSERT INTO tblpropertyrooms WHERE name='$name' (something) values ($something)";
It isn't modifying the record, simply leaving it the same.
You are using an INSERT SQL Statement ... to change information in a database you need to use UPDATE.
Like so:
UPDATE tblpropertyrooms SET <field> = <value> WHERE name='$name'
That should give you the general idea. http://www.mysql.com/doc/en/index.html for more sql help.
Thank you muchly!
