Off of

    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 =

For explanations of all args and options,
Hope that helps...


"Jas" <[EMAIL PROTECTED]> wrote in 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
> field.  My sql statement is as follows...
> $db_name = "localhost";
> $table_name = "table01";
> $connection = @mysql_connect("localhost", "user", "password") or die
> 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)
> (\"$new_area\")
> ";
> $result = @mysql_query($sql, $connection) or die ("Could not execute
> 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 (
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