OK, i guess i need to post code in my question? couldn't quite figure out the other way we were trying, so now trying to have an update page for entries in our database. Putting together bits and pieces of knowledge and sample code, we are left with something that was working and as we've evolved it, its not working. Can anyone help and see somthing thats wrong?
Thank you,
$id=$_GET['id'];
$con = mysql_connect("********",
"*****",
"*****");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("*****", $con);
$query=" SELECT * FROM usa WHERE id='$id'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$first=mysql_result($result,$i,"date");
$last=mysql_result($result,$i,"name");
$fax=mysql_result($result,$i,"color");
$email=mysql_result($result,$i,"discription");
<form method="post">
<input type="hidden" name="ud_id" value="<? echo $id; ?>">
Date: <input type="text" name="ud_date" value="<? echo $date; ?>"><br>
Customer: <input type="text" name="ud_name" value="<? echo $name; ?>"><br>
Color: <input type="text" name="ud_color" value="<? echo $color; ?>"><br>
Discription: <input type="text" name="ud_discription" value="<? echo $discription; ?>"><br>
<input type="Submit" value="Update">
</form>
$ud_id=$_POST['ud_id'];
$ud_date=$_POST['ud_date'];
$ud_name=$_POST['ud_name'];
$ud_color=$_POST['ud_color'];
$ud_discription=$_POST['ud_discription'];
$query="UPDATE contacts SET date='$ud_date', name='$ud_name', color='$ud_color', discription='$ud_discription' WHERE id='$ud_id'";
mysql_query($query);
echo "Record Updated";
mysql_close();
++$i;
}