Help making an "answers chart"

sapoxgn

Hi all..

I m not really sure if i ll be able to explain what i m trying to do.. btw.. i ll try...

I m making an system that is basically, a module with some questions, like a poll.

in the module i can have from 1 to 5 questions.. everything is working... but now i need to make a king of panel that shows wich module was answered and wich was not.

my database is like this (i ll simplify)

modules is related with the questions by "module_id", and the questions are related with the answers by "question_id".. so... i need to find out if the questions of that module is answered and then if it is it should return a "X", and it is not it sould return a "O".. i was trying someting like this:

here is the code that i was trying to make:

//edit: new code bellow

my code is all messed up.. i ve tryied a LOT of things.. but i cant find any ways to make it work 🙁

if anyone could help me out.. correcting my code of finding another solution i would be gratefull...

thanx 🙂

sapoxgn

Hi, i was trying to make it work, and now the query is working, i m sure of it:

function quadro() {
		$usuario = $_SESSION['user_id'];
		$query_respostas = mysql_query("SELECT DISTINCT enquete.modulo FROM respostas, enquete, modulo WHERE respostas.usuario='$usuario'  AND respostas.enquete=enquete.enquete_id ORDER BY enquete.modulo ASC") or die(mysql_error());
		$query_mod = mysql_query("SELECT modulo_id FROM modulo ORDER BY modulo_id ASC");
			while($modulos = mysql_fetch_assoc($query_mod)) {
				echo $modulos['modulo_id'];
				$respondido = '';
				while($resposta = mysql_fetch_assoc($query_respostas)) {
					if($resposta['modulo'] == $modulos['modulo_id']) {
						$respondido = 1;
					}
				}
				if($respondido == 1) {
					echo '<a href="modulos.php?id=' . $modulos['modulo_id'] . '"> X </a> | ';
				} else {
					echo '<a href="modulos.php?id=' . $modulos['modulo_id'] . '"> O </a> | ';
				}

		}
}

in the results i have 3 modules their code is: 1, 3 and 4

When do an: echo $resposta['modulo'] inside the while, it gives me 1, 3 and 4.

But it seens that the while loop isnt working.. cause just the first module is marked as answered... whats wrong with my code?

it seens that is checking just the fist loop, i ve tried with foreach but i got the same result 🙁

thanx