mysql_fetch_row problem code
Posted: Wed Jul 09, 2003 6:20 pm
This is the code that I am using to perform the required functions spoken about.
mysql_select_db("altura");
$sql = "select * from directory where pno like '%".$pno."%'";
$result = mysql_query($sql);
//$num_results = mysql_num_rows($result);
//for($i=0; $i <$num_results; $i++)
while($i = mysql_fetch_row($result))
{
echo $i[3];?>
<form action='uconfirm.php' method='post'>
<p>Update Employee Information</p>
<p> Last Name
<input type=text size=40 name=lname value=<?=$i[0]?>>
<br><BR>
First Name
<input type=text size=40 name=fname value=<?=$i[1]?>>
<br><BR>
Branch
<input type=text size=40 name=region value=<?=$i[2]?>>
<br><BR>
Title
<input type=text size=40 value=<?=$i[3]?>>
<br><BR>
<input type=submit value=Update></p></form></body>
</html>
<?
}
?>
mysql_select_db("altura");
$sql = "select * from directory where pno like '%".$pno."%'";
$result = mysql_query($sql);
//$num_results = mysql_num_rows($result);
//for($i=0; $i <$num_results; $i++)
while($i = mysql_fetch_row($result))
{
echo $i[3];?>
<form action='uconfirm.php' method='post'>
<p>Update Employee Information</p>
<p> Last Name
<input type=text size=40 name=lname value=<?=$i[0]?>>
<br><BR>
First Name
<input type=text size=40 name=fname value=<?=$i[1]?>>
<br><BR>
Branch
<input type=text size=40 name=region value=<?=$i[2]?>>
<br><BR>
Title
<input type=text size=40 value=<?=$i[3]?>>
<br><BR>
<input type=submit value=Update></p></form></body>
</html>
<?
}
?>