the code i was working with is below, but all i get is a blank page:
Code: Select all
<?php
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM data1 WHERE id='$id'";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
$i=0;
while ($i < $num) {
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$street=mysql_result($result,$i,"street");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$fee_rcpt=mysql_result($result,$i,"fee_rcpt");
$date_rcd=mysql_result($result,$i,"date_rcd");
$opnd_by=mysql_result($result,$i,"opnd_by");
$check_encl=mysql_result($result,$i,"check_encl");
?>
<form action="updated.php">
<input type="hidden" name="id" value="<?php echo "$id"; ?>">
First Name: <input type="text" name="first" value="<?php echo "$first"?>"><br>
Last Name: <input type="text" name="last" value="<?php echo "$last"?>"><br>
Street: <input type="text" name="street" value="<?php echo "$street"?>"><br>
City: <input type="text" name="city" value="<?php echo "$city"?>"><br>
State: <input type="text" name="state" value="<?php echo "$state"?>"><br>
Zip: <input type="text" name="zip" value="<?php echo "$zip"?>"><br>
Fee Rcd (Y/N): <input type="text" name="fee_rcpt" value="<?php echo "$fee_rcpt"?>"><br>
Date Rcd: <input type="text" name="date_rcd" value="<?php echo "$date_rcd"?>"><br>
Opened By: <input type="text" name="opnd_by" value="<?php echo "$opnd_by"?>"><br>
Check Encl (Y/N): <input type="text" name="check_encl" value="<?php echo "$check_encl"?>"><br>
<input type="Submit" value="Update">
</form>
<?php
++$i;
}
?>