[SOLVED] Query only returning one result?

[twilitegxa]

That didn't work either. I took the defects out of the table and just ran it all together and placed what looked like an outline for a table with nothing in it at the top of the page.

[Minase]

IE is a bastard  im 100% sure that in firefox no problem apear... but still its weird that it apear like that in IE

[twilitegxa]

I will check in FF.

[twilitegxa]

In FF it just doesn't display in a table and the Character Defects part is still repeating as well.

[twilitegxa]

I changed it to this code, and now it works perfectly:

 

//validate defects
$get_defects = "SELECT * FROM character_defects INNER JOIN scout USING (identity) WHERE scout.id = $_GET[id] ORDER BY defect_id ASC";

$get_defects_res = mysql_query($get_defects) or die (mysql_error());

if (mysql_num_rows($get_defects_res) < 1) {
//invalid table
$display_block .= "<p><em>Invalid table selection.</em></p>";
} else {
//valid table, get info
//That's where we start table
$display_block .= "  
<table cellpadding=3 cellspacing=3 border='0' width='40%' id='stats'>
<tr>
<tr><td colspan='3' id='th'>Character Defects</td></tr>
";
while($row = mysql_fetch_array($get_defects_res)) { //here we start the loop

$defect_id = stripslashes($row['defect_id']);
$desc = $row['desc'];
$bp = stripslashes($row['bp']);

//display defects
$display_block .= "<tr>
<td>$defect_id $desc</td>
<td>$bp BP</td></tr>";
} //here the loop ends

$display_block .="</table>";  //here the table ends

}