How to use a form to Update existing MySQL data

[tcape]

I'm finding bits and pieces, but this must be very simple since I'm not finding any specific examples.

What I want to do:

With a table displayed of existing mysql data on the page( I have this done already)

I want to have a form entry box so I can pick an item(indexed) from the table above and....

click submit and it grabs the correct row from my mysql table and inserts it and all the fields into a second form on the same page and....

I want to be able to change the data in the pre-filled second form and then click Update and it modifies the data in the table.

Can someone provide the correct syntax for this?

Thanks

Tony C

[badgoat]

Something like this:

if(!empty($_REQUEST['action']) && $_REQUEST['action'] == 'update')
{
        $id = $_REQUEST['id'];
        $_GET['id'] = $id;
        $query = "UPDATE `table` SET variable = '".$_REQUEST['new_variable]."' WHERE id='$id'";
        $result = mysql_query($query) or die("<b>mySQL Error:</b>".mysql_errono()."<br>".mysql_error());
        if(!$result)
        {
            echo 'Error processing request.';
        }
        else
        {
            echo '<B>The Record has been successfully updated!</B>';
        }
    }

$id = $_GET['id'];
	    // The ID is passed through the URL to specify the row,
// Or it is set in the previous script.

$query = "SELECT * FROM table WHERE id = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

echo '<form name="update" method="post">
    <input type="hidden" value="update" name="action">
    <input type="hidden" name="id" value="'.$id.'">

<TABLE>
<TR>
	<TD>Variable:<</TD>
	<TD><input type="text" name="new_variable" size="50" value="'.$row['variable'].'"></TD>
</TR>

<TR>
    <TD colspan=2><input type="submit" value="Update"> </CENTER></TD
</TR>

</TABLE>	';
?>