[RESOLVED] exit kills footer

[rikmoncur]

Multiple choice quiz:
I have six questions (Q1, Q2, Q3, Q4, Q5, Q6)
the answers are stored in six fields in a database.

If a student answers eg two questions and logs out, when he logs back in, I want to say "hello, begin again at question three".

I thought I could do this by finding the first empty field in the database? But I don't know how to do that.

I can do it by getting all the fields and writing (pseudocode) '...if Q2 is not empty, echo "hello, begin again at question three" EXIT. (so it doesn't go onto Q3)

And this works ok. Except that EXIT (or DIE or RETURN) kills the code and my page footer disappears.

I know this isn't explained well at all and it's probably the wrong approach?
If anyone's able to decipher it, here's the actual code:

 <?php 

if($row_Recordset1['m1q1'] !="") {echo "You have answered Question... ";} 
if($row_Recordset1['m1q1'] !="") {echo "1, ";} else {echo "Begin Module"; exit;}   if($row_Recordset1['m1q2'] !="") {echo "2, ";} else {echo "go to 2"; exit;}   if($row_Recordset1['m1q3'] !="") {echo "3, ";} else {echo "go to 3"; exit;}   if($row_Recordset1['m1q4'] !="") {echo "4, ";} else {echo "go to 4"; exit;}   if($row_Recordset1['m1q5'] !="") {echo "5, ";}  else {echo "go to 5"; exit;}  if($row_Recordset1['m1q6'] !="") {echo "6. You have completed this module."; exit;}  else {echo "go to 6"; exit;}

?>

<?php include('footer.php'); ?> 

[ClarkF1]

die and exit do the same thing and kill script execution so they don't show the footer. Return is used to return stuff from a function.

[rikmoncur]

thanx - yup, I've read the manual for exit, die and return.

a workaround would be to include the footer in every echo before the exit.

but i'm kinda hoping someone can give me a clue about how to detect the first empty field in the database.
i'm sure i'm coming at this from the wrong direction.

[wilku]

I'd do this that way:

$last = 6;
for ($i=1;$i<=6;$i++)
{
   if ($row_Recordset1['m1q'.$i] =="") 
   {
     $last = $i-1;
     break;
   }
}
if ($last>0) echo "You have answered questions up to $last";
if ($last<6) echo "Begin with question nr ".($last+1);
else echo "You have completed this module.";

[rikmoncur]

Woo hoo! thanx wilku - that's the right approach!
It works just fine!

thanx again!