Need help debugging my loop

Client Joined: Oct 07, 2003 Posts: 735 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.

http://www.donovanfamily.us/index_funtion.txt

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

http://www.donovanfamily.us/displayReply_function.txt

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.

registered · 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)?

Posted: Mon Sep 24, 2007 6:26 am

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.

Posted: Mon Sep 24, 2007 8:52 am

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

Posted: Tue Sep 25, 2007 6:10 am

Cool...