problem showing results

[jdnet]

i'm still a n00b at this stuff, but i gotta learn somehow, however im stumped here. I've used similar statements to search the database to see if other values exsisted, and it WORKS here (i put print "yes if it finds matches"; and it did say that when i entered an exsisting postid) but when i goto print the row's it gives me nothing (i just used a simple output just till i got it working)....i dont know whats wrong....

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

while($row=mysql_fetch_row($result))
{
  if($postid==$row[0])
   {
    $match=true;
   }
}
if($match)
{
print "$row[2]";
print "$row[3]";
}
else
{
print "<P>There is no topics found with that ID";
}

[jdnet]

just an update, i got the info to show, but its not looping (its only showing the first reply)...any ideas?

$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 is no topics found with that ID";
} 
   print "</table>\n";

[njm]

Why not do the matching in the SQL statement?

$query3 = "SELECT postid, replyid, name, comment, date FROM thought_reply WHERE postid='$postid' ORDER BY date DESC";

then you're only pulling the results you want, rather than make PHP loop through everything

hth, njm