Query Help

Help!

Im trying to write a query that will pull quiz reults from a table. I need to have the participants # (id_pax), and then I wanted to have the questions across the top (each in its own column) and the anwser below.

Currently the table I am pulling from holds all quiz results and each question/anwser is its own unique line. The quiz has 6 questions total so each particpant has 6 lines but I want to pull the reults as one line her participants where their anwsers to each question.

Help please

I think you're confusing issues of data display (normally managed at the application level - e.g. with a bit of PHP) with those of storage and retrieval (managed at the SQL end).

See normalization.

I do not have access to change the database. The table is current pax_id, quistion_nbr, anwser. So there are 6 results for each particpant (id_pax). Can I write a query to pull the results so that it only lists the id_pax once with each question/anwser?

no, you would do that in php

that comment about normalization doesn't apply to you