Could anyone help me out with the update command in php? I am trying to update a unique field on a table, or overwrite the current contents of said field. My sql statement is as follows... $db_name = "localhost"; $table_name = "table01"; $connection = @mysql_connect("localhost", "user", "password") or die ("Could not connect to database. Please try again later."); $db = @mysql_select_db("$db_name",$connection) or die ("Could not select database table. Please try again later."); $sql = " UPDATE $table_name (new_area) VALUES (\"$new_area\") "; $result = @mysql_query($sql, $connection) or die ("Could not execute query. Please try again later.");
My question is if someone could give me an example of the UPDATE command I would appriciate it. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]