Updating Table Rows

txrandom

I'm making a small site that stores info that you submit. Right now I can add info and delete info from the database. Now I'm trying to make a script where you can edit all the fields in a row at once.

Here is how I add data that I get from a form:

$query = "INSERT INTO ea(org, pos, ele, lev, fr, so, jr, sr, userid)
VALUES('".$POST['org']."','".$POST['pos']."','".$POST['ele']."','".$POST['lev']."','".$POST['fr']."','".$POST['so']."','".$POST['jr']."','".$POST['sr']."','".$_GET['userid']."')";
$result = mysql_query($query);

Here is what I think will work when trying to update it, but I'm hesistant to try it:

$query = "UPDATE ea WHERE ID=$id(org, pos, ele, lev, fr, so, jr, sr)
VALUES('".$POST['org']."','".$POST['pos']."','".$POST['ele']."','".$POST['lev']."','".$POST['fr']."','".$POST['so']."','".$POST['jr']."','".$POST['sr']."')";
$result = mysql_query($query);

ID is just the name of the row, and the link to the edit will provide what row(ID) number I need to edit. Will this just simply replace all the values in the given row? I couldn't find any good examples on how to update more than one record at a time.

Thanks, btw I don't know how to format PHP code on this forum yet.

txrandom

Actually I did some searching and it looks like a script like this will work:

$ud_id=$POST['ud_id'];
$ud_first=$POST['ud_first'];
$ud_last=$POST['ud_last'];
$ud_phone=$POST['ud_phone'];
$ud_mobile=$POST['ud_mobile'];
$ud_fax=$POST['ud_fax'];
$ud_email=$POST['ud_email'];
$ud_web=$POST['ud_web'];

$username="username";
$password="password";
$database="your_database";
mysql_connect(localhost,$username,$password);

$query="UPDATE contacts SET first='$ud_first', last='$ud_last', phone='$ud_phone', mobile='$ud_mobile', fax='$ud_fax', email='$ud_email', web='$ud_web' WHERE id='$ud_id'";
mysql_query($query);
echo "Record Updated";
mysql_close();