hey there, i have done the kind of thing you want, im new to this so im not sure how to ecplain it but if you look at my code you may be able to see what pieces you need. <HTML> <BODY> <body bgcolor="#FFFFCC" text="#006600" link="#0000FF" vlink="#0000FF" alink="#0000FF"> <?php $db=mysql_connect("localhost","hnd",""); mysql_select_db("hnd",$db); if($Submit2) { $sql="UPDATE RB_Customer SET Title = '$Title', First_Name = '$First_Name', Last_Name = '$Last_Name', Age = '$Age', Address_Line_1 = '$Address_Line_1', Address_Line_2 = '$Address_Line_2', City = '$City', County = '$County', Postcode = '$PostCode', Telephone_Number = '$Telephone_Number', E_Mail = '$E_Mail' WHERE Cust_Number = '$Cust_Number'"; $result=mysql_query($sql,$db); echo "$sql Record updated/edited!<p>"; } if($Submit) { $sql="SELECT * FROM RB_Customer WHERE Cust_Number='$ID'"; $result=mysql_query($sql,$db); $myrow = mysql_fetch_array($result); echo" <form method = \"post\" action = \"updatecust2.php\"> Title:<input type = \"Text\" name=\"Title\" value='$myrow[11]'<BR> First_Name:<input type = \"Text\" name=\"First_Name\" value='$myrow[1]'<BR> Last_Name:<input type = \"Text\" name=\"Last_Name\" value='$myrow[2]'<BR> Age:<input type = \"Text\" name=\"Age\" value='$myrow[3]'<BR> Address_Line_1:<input type = \"Text\" name=\"Address_Line_1\" value='$myrow[4]'<BR> Address_Line_2:<input type = \"Text\" name=\"Address_Line_2\" value='$myrow[5]'<BR> City:<input type = \"Text\" name=\"City\" value='$myrow[6]'<BR> County:<input type = \"Text\" name=\"County\" value='$myrow[7]'<BR> Postcode:<input type = \"Text\" name=\"PostCode\" value='$myrow[8]'<BR> Telephone_Number:<input type = \"Text\" name=\"Telephone_Number\" value='$myrow[9]'<BR> E_Mail:<input type = \"Text\" name=\"E_Mail\" value='$myrow[10]'<BR> Cust_Number:<input type = \"Text\" name=\"Cust_Number\" value='$myrow[0]'<BR> <input type = \"Submit\" name=\"Submit2\" value = \"Enter Information\"> "; } $result=mysql_query("SELECT * FROM RB_Customer",$db); echo "<table border=1>\n"; echo "<TR> <TD><h2>Customer Number</h2></TD> <TD><h2>Title</h2></TD> <TD><h2>First Name</h2></TD> <TD><h2>Last Name</h2></TD> <TD><h2>Age</h2></TD> <TD><h2>Address Line 1</h2></TD> <TD><h2>Address Line 2</h2></TD> <TD><h2>City</h2></TD> <TD><h2>County</h2></TD> <TD><h2>PostCode</h2></TD> <TD><h2>Telephone Number</h2></TD> <TD><h2>E-Mail Address</h2></TD> </TR>\n"; while($myrow = mysql_fetch_array($result)){ echo " <TR> <TD><h3>$myrow[0]</h3></TD> <TD><h3>$myrow[11]</h3></TD> <TD><h3>$myrow[1]</h3></TD> <TD><h3>$myrow[2]</h3></TD> <TD><h3>$myrow[3]</h3></TD> <TD><h3>$myrow[4]</h3></TD> <TD><h3>$myrow[5]</h3></TD> <TD><h3>$myrow[6]</h3></TD> <TD><h3>$myrow[7]</h3></TD> <TD><h3>$myrow[8]</h3></TD> <TD><h3>$myrow[9]</h3></TD> <TD><h3>$myrow[10]</h3></TD> </TR>"; } echo "</table>\n"; ?> <form method = "post" action = "<?php echo $PHP_SELF?>"> ID:<input type = "Text" name="ID"><BR> <input type = "Submit" name="Submit" value = "Choose Record To Be Updated"> </BODY> </HTML>