Display Results

[treeleaf20]

I have the following query:

$querysub = "SELECT subject from mail where user_id='$userid'";
$resultsub = mysql_query($querysub);
$sub = mysql_fetch_array($resultsub);

I try and display it like this but it won't work, it only displays the first row:

if (mysql_num_rows($result) > 0) {
for ($j = 0; $j<mysql_num_rows($result); $j++) {
echo "<tr><td><input type=\"checkbox\"></td><td>$sub[$j]</td>";	   			 }
}

Can anyone help me display all of the rows in the db? Thanks for the help.

It displays the 2 checkboxes for the rows but it doesn't display the actual subject.

Thanks.

[devinemke]

$result = mysql_query("SELECT subject FROM mail WHERE user_id = '$userid'") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	print_r($row);                   

}

[treeleaf20]

That gets them both the problem is there are other things in the row, that is why I wanted to do it that way.

So I wanted it to look like:

Title Subject Status
Title1 Subject1 Status1
Title2 Subject2 Status2

With that method I couldn't specifiy where I wanted the subject to show up. Any more ideas?

Thanks