[Resolved] looping problems

[jdnet]

i posted this in the mysql forums but i think this is more php related...

anyway...i have a problem, its currently only displaying the first comment, not all of them (if i take away the desc, it shows the latest post) but not all of them. I cannot figure out whats wrong, could anyone offer any suggestions?

$match=false;
$mysql_access=mysql_connect("xxx", "xxx", "xxx");
mysql_select_db("xxx");
$query3 = "SELECT postid, replyid, name, comment, date FROM thought_reply order by date desc";
$result = mysql_query($query3) or die("Query failed : " . mysql_error());

while($row=mysql_fetch_row($result))
{
  if($postid==$row[0])
   {
    $match=true;
    $name=$row[2];
    $comment=$row[3];
    $date=$row[4]; 
   }
}
print "<table>\n";
if($match)
{
 print "<tr>";
   print "<td><b>$name</b></td>";
   print "<td>&nbsp;</td>";
  print "</tr>";
  print "<tr>";
    print "<td colspan='2'>$comment</td>";
  print "</tr>";
}
else
{
 print "<P>There are no comments associated with that post";
} 
   print "</table>\n";

[crosbystillsnas]

$i = 0;
while($row=mysql_fetch_row($result)) 
{ 
  if($postid==$row[$i][0]) 
   { 
    $match=true; 
    $name=$row[$i][2]; 
    $comment=$row[$i][3]; 
    $date=$row[$i][4];  

   }

  $i++;
}

...does this help?

[jdnet]

nope, now nothing shows up 🙁 i've been trying, but i cant seem to figure it out

[swr]

The print statements should be inside the while loop. That way they will be invoked each time through the loop (once for every row).

If you don't understand what the while loop is for, you should try to find an introductory PHP programming tutorial.

[jdnet]

Originally posted by swr
The print statements should be inside the while loop. That way they will be invoked each time through the loop (once for every row).

If you don't understand what the while loop is for, you should try to find an introductory PHP programming tutorial.

ahh yes, i forgot to put it inside, it works now, thanks!