database problem

[Anon]

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='$row->name'></td>";
                              echo "<td align=middle><input type=text name='email' value='$row->email'></td>";
                              echo "<td align=middle><input type=text name='extension' value='$row->extension'></td>";
                              echo "<td align=middle><input type=text name='nick' value='$row->nick'></td></tr>";
                          $id = $row->id;
                          }

[jariizumi]

Use something like
$r["name"] instead of $row->name... and be sure to quote-out:

echo "<td align=middle><input type=text name='name' value='".$row["name"]."'></td>";

Hope this helps 🙂

[Anon]

i have try it , the text box inside is still blank. Need to solve this urgently. Thanks

[[deleted]]

have you tried printing the $row->name on a single line:

echo $row->name;

to see if that works?

[smarlowe]

the problem looks like you're quoting an integer in your query:

select * from table where id='$id'

should be

select * from table where id=$id