First off, never put a DB query (you have two, which is even worse) into a while loop of another DB query.
Bad news, as it could call hundreds of queries thus slowing your system down.
If you've tried LEFT JOIN'ing tables and that doesn't prove successful, there is usually a way to make arrays containing the data you want from each query, and then you can make one main loop and iterate through the arrays and sort the data.
Hard to explain so I'll try to give an example.
But first, how is this setup? Looks like you have a table for questions, a table for correct answers, and a table for user answers.
How about combining the first two tables, questions and correct answers? Have the fields in one table.
|
04-12-2004, 01:56 AM
Hybrid Mode
