how to update database?

Anon

i done this script :
<body>
<?php
if(page=="") {
$db = mysql_connect("localhost", "root","");
mysql_select_db("mydb", $db);
$result = mysql_query("SELECT * FROM users", $db);
$first = mysql_result($result, 0, "first");
$last = mysql_result($result, 0, "last");
$address = mysql_result($result, 0, "address");
$company = mysql_result($result, 0, "company");
}
?>
<form method="post" action="<?php print("$PHP_SELF"); ?>">
First Name: <input type="text" name="first1" value="<? printf($first); ?>"><br>
Last Name: <input type="text" name="last1" value="<? printf($last); ?>"><br>
Address: <input type="text" name="address1" value="<? printf($address); ?>"><br>
Company: <input type="text" name="company1" value="<? printf($company); ?>"><br>
<input type="submit" name="update" value="update">
<input type="hidden" name="page" value="update">
</form>
</body>
now how do i update it?

Anon

First, you need to set a HIDDEN filed in the FORM, containing the unique id of that row in the table.

After, when you submit the form, use the following query:

UPDATE users SET first = '".$first1."',last = '".$last1."',address = '".$address."',company = '".$company."' WHERE unique_id = ".$hidden_field_containing_id.";

hope it helps

fLIPIS

tomhath

I've always found it easiest to learn this kind of thing by looking at working examples. This article continues what you have already started:

http://www.devarticles.com/content.php?articleId=23

Anon

Right, mate. You know the old saying:

"If you giv a fish to a hungry man, he'll eat this day. But if you teach him to fish, he won't be hungry anymore"

fLIPIS