RE: [PHP-DB] MySQL Update command syntax

2002-02-01 Thread Rick Emery
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

[PHP-DB] MySQL Update command syntax

2002-02-01 Thread jas
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