The code below was suppose to show a form with data filled in from database and allow me to update based on _id. Once form is submited to updated.php (code also below) Echo Files updated. This is converted from a tutorial I used. I can add to the database and view info added , but can't make this update work. This is my first attemt to make an interactive form for my website and being very green at this I need serious help!
UPDATE CODE:
<?
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$cell=mysql_result($result,$i,"cell");
$fax=mysql_result($result,$i,"fax");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
?>
<form action="updated.php">
<input type="hidden" name="ud_id" value="<? echo "$id"; ?>" />
First Name: <input type="text" name="ud_first" value="<? echo "$first"?>" />
<br />
Last Name: <input type="text" name="ud_last" value="<? echo "$last"?>" />
<br />
Phone: <input type="text" name="ud_phone" value="<? echo "$phone"?>" />
<br />
Cell: <input type="text" name="ud_mobile" value="<? echo "$cell"?>" />
<br />
Fax: <input type="text" name="ud_fax" value="<? echo "$fax"?>" />
<br />
Address: <input type="text" name="ud_address" value="<? echo "$address"?>" />
<br />
City: <input type="text" name="ud_city" value="<? echo "$city"?>" />
<br />
State: <input type="text" name="ud_state" value="<? echo "$state"?>" />
<br />
Zip: <input type="text" name="ud_zip" value="<? echo "$zip"?>" />
<br />
Email: <input type="text" name="ud_email" value="<? echo "$email"?>" />
<br />
Web Address: <input type="text" name="ud_web" value="<? echo "$web"?>" />
<br />
<input type="submit" value="Update" />
</form>
<?
++$i;
}
?>
UPDATED CODE:
<?
$ud_id=$POST['ud_id'];
$ud_first=$POST['ud_first'];
$ud_last=$POST['ud_last'];
$ud_phone=$POST['ud_phone'];
$ud_cell=$POST['ud_cell'];
$ud_fax=$POST['ud_fax'];
$ud_address=$POST['ud_address'];
$ud_city=$POST['ud_city'];
$ud_state=$POST['ud_state'];
$ud_zip=$POST['ud_zip'];
$ud_email=$POST['ud_email'];
$ud_web=$POST['ud_web'];
mysql_connect(localhost,$username,$password);
$query="UPDATE contacts SET first='$ud_first', last='$ud_last', phone='$ud_phone', cell='$ud_cell', fax='$ud_fax', address='$ud_address', city='$ud_city', state='$ud_state', zip='&ud_zip', email='$ud_email', web='$ud_web' WHERE id='$ud_id'";
@mysql_select_db($database) or die( "Unable to select database");
mysql_query($query);
echo "Record Updated";
mysql_close();
?>
