Can't figure this out??

[Anon]

Here is some code that was working but now is not and I cannot figure out why. It is entering zero into the database even if the student enters the correct answer on the form. The database is fine and this code is working on other tests on the site. What could be causing the code to fail?

$numone=1;
$numtwo=0;

if (($calc9 == "answer9") && ($calc6 =="") && ($calc7 =="")
&& ($calc8 =="") && ($calc10 ==""))
{
mysql_query("UPDATE demo set questionthree = $numone WHERE id = $session3[id]");
}
if (($calc6 =="") && ($calc7 =="") && ($calc8 =="") && ($calc9 =="") && ($calc10 =="")) {
$message3 .="You forgot to answer a question! Please resubmit your answers.";
}
else

{
mysql_query("UPDATE demo set questionthree = $numtwo WHERE id = $session3[id]");
}

[phigga]

It seems to me that what is happing is in the first if statement, you are updating questionthree to '1'. then the code moves to the next if statement. there, if the user didn't answer a question, you output the error message, but if they DID answer the question (just like in the first if) this time you set questionthree to '0'.

Basically, no matter what, if the user answers a question, questionthree is set to '0'.

the remedy? change the second 'if' statement to 'else if', so it looks like this:

                       $numone=1; 
                       $numtwo=0; 

                       if (($calc9 == "answer9") && ($calc6 =="") && ($calc7 =="") 
                       && ($calc8 =="") && ($calc10 =="")) 
                       { 
                       mysql_query("UPDATE demo set questionthree = $numone WHERE id = $session3[id]"); 
                       } 
                       else if (($calc6 =="") && ($calc7 =="") && ($calc8 =="") && ($calc9 =="") && ($calc10 =="")) { 
                       $message3 .="You forgot to answer a question! Please resubmit your answers."; 
                       } 
                       else 
                       { 
                       mysql_query("UPDATE demo set questionthree = $numtwo WHERE id = $session3[id]"); 
                       } 

[vsego]

First if() doesn't have "else". Is that it?

[phigga]

wow, that sure sounds like the advice i just gave....

[vsego]

Sure. It must be correct then.

When I opend the original post, your answer was not there yet. :-)

[phigga]

Ah k....

Yeah...i think we're both right :-)