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]

Reply via email to