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]

Reply via email to