i try the following code.But there is no data reflect, when i try to print using the $row->name there is no data reflected , i have check that the query is correct.
code as follows
$query1 = "select * from contact where id = '$id'";
$result1 = mysql_db_query('mydb',$query1);
while($row = mysql_fetch_object($result1)) {
echo "<td align=middle><input type=text name='name' value='http://www.phpbuilder.com/board/archive/index.php/$row->name'></td>";
echo "<td align=middle><input type=text name='email' value='http://www.phpbuilder.com/board/archive/index.php/$row->email'></td>";
echo "<td align=middle><input type=text name='extension' value='http://www.phpbuilder.com/board/archive/index.php/$row->extension'></td>";
echo "<td align=middle><input type=text name='nick' value='http://www.phpbuilder.com/board/archive/index.php/$row->nick'></td></tr>";
$id = $row->id;
}
code as follows
$query1 = "select * from contact where id = '$id'";
$result1 = mysql_db_query('mydb',$query1);
while($row = mysql_fetch_object($result1)) {
echo "<td align=middle><input type=text name='name' value='http://www.phpbuilder.com/board/archive/index.php/$row->name'></td>";
echo "<td align=middle><input type=text name='email' value='http://www.phpbuilder.com/board/archive/index.php/$row->email'></td>";
echo "<td align=middle><input type=text name='extension' value='http://www.phpbuilder.com/board/archive/index.php/$row->extension'></td>";
echo "<td align=middle><input type=text name='nick' value='http://www.phpbuilder.com/board/archive/index.php/$row->nick'></td></tr>";
$id = $row->id;
}