php mysql display selected records from result set

Question

I have a query which fetches replies to comments. so my first query has them comments, e.g.

comment 1 <BR>
  &nbsp; reply 1<BR>
comment 2<BR>
comment 3<BR>
   &nbsp; reply 1<BR>
   &nbsp; reply 2<BR>
   &nbsp; reply 2<BR>

Comment 3 has 3 replies. I make one query to fetch all replies from my database where the commentID in (1,2,3) . This will bring me all valid replies.

Now the problem is when I want to display the results, I start a while loop and go through all the comments.

How do I get the selected replies just for that particular comment while in the while loop?

That's what i initially used to do , but i was told to do it this way in another post , but i dont understand how to .... — Zaid Kajee
– Zaid Kajee, Commented Aug 8, 2012 at 17:14

victoroux · Accepted Answer · 2012-08-08 17:25:29Z

2

Assuming you stored the replies in a multidimensional array lets say $array_replies, this is how youd do it

for ($i=0; $i<count($array_replies[$commentID]); $i++) {
   echo $array_replies[$commentID][$i];
}

edited Aug 8, 2012 at 17:25

victoroux

2862 silver badges11 bronze badges

answered Aug 8, 2012 at 17:10

mlishn

1,66714 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zaid Kajee Over a year ago

my replies record set will return 4 rows, and if i was in the while loop at the point where i was displaying the replies for comment 3 , i would only like to dispaly 3 of the records from the result where they match the commentID

Collectives™ on Stack Overflow

php mysql display selected records from result set

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related