Menu
Hi, I’m have trouble with this code.
I wants it finds and displays datas of a record that match the id given by $id to the form below.
Please help me ASAP. Thanks.
<?
$id=$_GET[‘txtName’];
$username=”root”;
$password=””;
$database=”Database”;
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( “Unable to select database”);
$query=”SELECT * FROM Company”;
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num)
{
$name=mysql_result($result,$i,”Name”);
$address=mysql_result($result,$i,”Address”);
$district=mysql_result($result,$i,”District”);
$province=mysql_result($result,$i,”Province”);
$phone=mysql_result($result,$i,”Phone”);
$fax=mysql_result($result,$i,”Fax”);
$email=mysql_result($result,$i,”Email”);
$web=mysql_result($result,$i,”Website”);
?>
<form action=”updated.php”>
<input type=”hidden” name=”ud_id” value=”<? echo “$id”; ?>”>
Name: <input name=”ud_name” type=”text” value=”<? echo “$name”?>” size=”50″ maxlength=”50″>
<br>
Address: <input name=”ud_address” type=”text” value=”<? echo “$address”?>” size=”30″ maxlength=”30″>
<br>
District: <input name=”ud_district” type=”text” value=”<? echo “$district”?>” size=”20″ maxlength=”20″>
<br>
Province: <input name=”ud_province” type=”text” value=”<? echo “$province”?>” size=”20″ maxlength=”20″>
<br>
Phone: <input name=”ud_phone” type=”text” value=”<? echo “$phone”?>” size=”20″ maxlength=”20″>
<br>
Fax: <input name=”ud_fax” type=”text” value=”<? echo “$fax”?>” size=”20″ maxlength=”20″>
<br>
E-mail: <input name=”ud_email” type=”text” value=”<? echo “$email”?>” size=”30″ maxlength=”30″>
<br>
Website: <input name=”ud_web” type=”text” value=”<? echo “$web”?>” size=”30″ maxlength=”30″>
<br>
<input type=”Submit” value=”Update”>
</form>
<?
$i++;
}
?>
Thanks for viewing this ?