really stuck and need help.

[brycenagels]

Hi all!

  I hope someone here ca nhelp me! 

  Here is my problem:

  I am creating a report for a system I ahve set up. It uses a postgres SQL database and I programed it with php using pear.

this report compares a variable amount of questionnaires filled out by clients for any given year. Each questionnaire has about 27 questions, my problem is I can create the right sql statement to get the apropriate questionnaires but don;t know how to access each question for each questionnaire...

here is an example:

question 1:

  questionnaire 1 : answer
  questionnaire 2 : answer
  questionnaire 3 : answer

question 2:

  questionnaire 1 : answer
  questionnaire 2 : answer
  questionnaire 3 : answer

and so on...

I am a little out of ideas so any help would be much appreciated!

Cheers, Bryce.