php mysql_num_rows

[Guest]

I'm trying to loop out 10 rows of comment, but this code only displays comment one time, how do I display all rows?

 

$query = "SELECT * FROM ".$prefix."comments WHERE userto = '".$user."' ORDER BY comment DESC LIMIT 0, 10";
$result = mysql_query($query);
$num = mysql_num_rows($result);

//Loop out code
$i=0;
while ($i < $num) {
    $comments=@mysql_result($result,$i,"comment");
    $i++;
}

[Pikachu2000]

Change this part to initialize an empty $comments variable before the loop, then use the concatenation operator .= instead of the assignment operator =

 

Also, you should list the fields you want to SELECT in your query instead of using a wildcard SELECT *

 

$i=0;
$comments = '';
while ($i < $num) {
    $comments .= mysql_result($result,$i,"comment");
    $i++;
}

[Guest]

Change this part to initialize an empty $comments variable before the loop, then use the concatenation operator .= instead of the assignment operator =

 

Also, you should list the fields you want to SELECT in your query instead of using a wildcard SELECT *

 

$i=0;
$comments = '';
while ($i < $num) {
    $comments .= mysql_result($result,$i,"comment");
    $i++;
}

 

Thank you for the tip and the quick fix.