November 6th, 2012, 11:52 AM
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.
November 6th, 2012, 12:27 PM
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).
November 6th, 2012, 01:07 PM
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?
Originally Posted by cafelatte
November 6th, 2012, 03:23 PM
no, you would do that in php
Originally Posted by Jam_ica
that comment about normalization doesn't apply to you