binding data to edit boxes

Anon

This is what I want to do, I want to take loginid and password as an input and on press of the GetInfo, I want to make a search on the database and retrive the firstname and last name and put them in the edit boxes First name and last name and then they could change the names and this could be apllied to the database... this is where I got with the code.. I am stuck at binding the data returned to the edit boxes.. please help...

<head>
<title>Welcome</title>
</head><body bgcolor=ffffff>
<form method=post action='<?php echo $PHP_SELF ?>'>
<center>
<table width=100% border=0>
<tr><td width=30% align=right><font face=Arial size=-1 >Login ID:</font></td>
<td width=70%><input type=text name='login' value='' maxlength=32 ><font face=Arial size=-1></font>
<font face=Arial size=-1><input type=submit name='getinfo' value='Get Info' maxlength=10 ><font face=Arial size=-1></font>
</td></tr>
<tr><td width=30% align=right><font face=Arial size=-1 >Password:</font></td>
<td width=70%><input type=password name='pw1' value='' autocomplete=off size=20 maxlength=32 ></td></tr>
</table></td>
<tr><td colspan=4><hr size=0> </td></tr>
<tr><td colspan=3>
<table width=100% border=0>
<tr><td width=30% align=right><font face=Arial size=-1 >First Name:</font></td>
<td width=70%><input type=text name='fname' value='' size=10 maxlength=50 >  
<font face=Arial size=-1 >Last Name: </font><input type=text name='lname' value='' size=10 maxlength=50 ></td></tr>
<tr><td colspan=2></td></tr></font><p></td></tr>
</table></center></form>
<?php
if (isset($getinfo)) {
$db = mysql_connect("localhost","root","passwd");
mysql_select_db("test",$db);
$query = "Select * from tblmembers where loginid = '$login' AND passwd = '$pw1'";
$result = mysql_query ($query) or die ("Select Query failed");
$num_results = mysql_num_rows($result);
$row = mysql_fetch_array($result);
echo $row["loginid"];
}
?>
</body>

Anon

i think you are not providing value in the value of edit box.

<td width=30% align=right>First Name:</td>
<td width=70%><input type=text name='fname' value='(Here it is blank)' size=10 maxlength=50 >

you have to put some data so that it can

say value='<? echo $loginid; ?>'

this will bind , i think this was your problem

Anon

Here is my problem, I first show 4 edit boxes, loginid, password , firstname and lastname out of which only 2 boxes are used for input, loginid and password, so I show the other two edit fields as blank name=\'fname\' value=\'\'

now after I fetch the data from the db, i want to bind it to the columns, I tried using the html code after the php code and inside the php code like this but this creates 2 more boxes, how do i bind it to the ones previuosly created...
<?php
if (isset($getinfo)) {
$db = mysql_connect(\"localhost\",\"root\",\"psswd\");
mysql_select_db(\"test\",$db);
$query = \"Select * from tblmembers where loginid = \'$login\' AND passwd = \'$pw1\'\";
$result = mysql_query ($query) or die (\"Select Query failed\");
$num_results = mysql_num_rows($result);
$row = mysql_fetch_array($result);

<table width=100% border=0>
<tr><td width=30% align=right>First Name:</td>
<td width=70%><input type=text name=\'fname\' value=\'<? echo ($row[\"Fname\"]); ?>\' size=10 maxlength=50 >

Last Name: <input type=text name=\'lname\' value=\'<? echo ($row[\"Lname\"]); ?>\' size=10 maxlength=50 ></td></tr>
<tr><td colspan=2></td></tr><p></td></tr>

}
?>