Need help debugging my loop

Donovan · Client Joined: Oct 07, 2003 Posts: 691 Location: Ohio

This displays all comments or questions from a student population.

The reply from a course director ($rid) need to be displayed just underneath its corrosponding question ($cid).

Comment table
$cid

Reply table
$rid
$cid

Each record in the reply table will have a matching cid from the comment table.

I have to figure out the proper loop and why I was getting all 4 replies for a single comment.

Only registered users can see links on this board!
Get registered or login to the forums!

I also have another way of doing this by using another function and passing the $cid.

Only registered users can see links on this board!
Get registered or login to the forums!

Not quite working as planned but I'm almost ready to demo this.

Just need to figure out why I was getting all my replies displaying under one comment.

montego · Posted: Mon Sep 24, 2007 6:06 am

Donovan, it appears that you have a one-to-many relationship between these two tables, so, how were you wanting to restrict the comments to just one? What would be your functional requirement for this restriction (i.e., in words)?

Donovan · Client Joined: Oct 07, 2003 Posts: 691 Location: Ohio

Well every rid has a corrosponding cid taken when the reply is sent. The cid is inserted into the reply table to link the two.

I thought a simple

Code:

SELECT * FROM reply r JOIN comments c WHERE c.cid= r.cid

would do the trick.

Donovan · Client Joined: Oct 07, 2003 Posts: 691 Location: Ohio

I just made this all one query and it seems to work.

montego · Posted: Tue Sep 25, 2007 6:10 am

Cool...