Calliphoridae (pkbarbiedoll) wrote in mysql,
Calliphoridae
pkbarbiedoll
mysql

A question of logic

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?
  • Post a new comment

    Error

    default userpic
  • 6 comments