Resource id #5
Posted: Tue Feb 15, 2011 12:39 pm
Hello. I have one code but its shows echo "Resource id #5". How to fix it?
Thanks
Thanks
Code: Select all
$name = $_POST["player_name"];
$sql = mysql_query("SELECT * FROM player_extra WHERE name = '".$name."'");
while($row = mysql_fetch_assoc($sql)) {
$id = $row['player_id'];
$sql2 = mysql_query("SELECT * FROM player_race WHERE id = '".$id."' ORDER BY race_id");
$row2 = mysql_fetch_assoc($sql2);
echo "<table border='1'>
<tr>
<th>user</th>
<th>Points</th>
</tr>";
echo "<tr>";
echo "<td>". $name. "</td>";
echo "<td>" .$sql2. "</td>";
echo "</tr>";
echo "</table>";
}