MySQL Update command syntax
| From: | jas | Date: | Sun, 27 Jan 2002 04:48:56 +0000 |
| Subject: | MySQL Update command syntax | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16416@lists.php.net to get a copy of this message | ||
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