Vincent
|
| Posted: 04/21/2002, 1:07 PM |
|
Still struggling with the following: people fill in a questionnaire on my website. All results go into a MySQL database (I use PHP w/templates), more precisely, into one table. A report is produced after a certain period of time. What I would like to get is sth like this:
Question 1:
Answer from person 1
Answer from person 2
Question 2:
Answer from person 1
Answer from person 2
.....
I managed to do that by creating a different form per question but this is not a good solution. Any idea on how to achieve this? I guess the solution is to write the right SQL statement but I have not been succesful so far... Using arrays maybe? I had a look at the quizz example but this does not help since what I have to do is show the records coming from one table.
Thanks!
|
|
|
 |
Nicole
|
| Posted: 04/22/2002, 5:02 AM |
|
Hello,
as all information is stored in one table I think this article should help you:
http://www.gotocode.com/art.asp?art_id=103&
|
|
|
|
|
