Correct your example as follows:
$sql = "UPDATE $table_name SET new_area=\"$new_area\"";
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 26, 2002 10:49 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Update command syntax
Could any
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", "passwor