this is part of an update info page
Code: Select all
$query = "SELECT username, first_name, last_name, address, email FROM Customers WHERE (username='$un' AND first_name='$fn')";
$result = @mysql_query($query) or die (mysql_error());
$num = mysql_num_rows ($result);
if ($num == 1)
{
$row = mysql_fetch_array ($result, MYSQL_NUM);
}
else
{
$message = '<P>Your Details Could Not Be Retrieved Due To A System Error!!</P><P>'
. mysql_error() . '</P>';
}
mysql_close();to insert the selected data into the field i am using
Code: Select all
<INPUT TYPE="text" NAME="Username" SIZE="15" MAXLENGTH="40" value="<?php echo $row['username']; ?>">as always your help is much appreciated