Off of MySQL.com: UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [LIMIT #]
So a typical UPDATE command could be UPDATE email_table SET email = '[EMAIL PROTECTED]' WHERE id = '1'; For explanations of all args and options, http://www.mysql.com/doc/U/P/UPDATE.html Hope that helps... -L "Jas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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]