Date: 03/02/10 (MySQL Communtiy)    Keywords: php

I've struggled with this for a few days now and thought some of you may have insight.

I need to display four columns of data from this table:

review_id
member_id
question_id
answer_id

(Review_id is a set of questions given to a member. Each colum represents questions for a given member, from a specific review_id. The idea is to compare review answers between 4 members)


Displaying a single member's results is easy enough to query. But where I am stuck is showing multiple member question/answers on the same screen, side by side. I'm tempted to nest queries with PHP. But maybe there is a better way?

I cannot change the layout of the page -- must have four columns, with answers listed on each row.

Thoughts?

Source: http://mysql.livejournal.com/138208.html