Should be simple ...

Anon

I have a problem with the following query and code:

$next_query = "select $Answer
from $Table2
where Question_no = '$Qu_no'";

$next_result = mysql_query($next_query);

if ($next_result == "C")
{
//process1
}
elseif (next_result != "C")
{
//process2
}

The query works, and the value "C" is taken from the the database. But, there is a problem with the if statement, process1 should be processed, but instead it is doing process 2. Why is '$next_result = "C" ' not registering?

Can someone please help.

Thanks, Sarah

Anon

try this code instead:

$next_query = "select Answer
from $Table2
where Question_no = '$Qu_no'";

$next_result = mysql_query($next_query);
$Answer=mysql_result($next_result,0,"Answer");

if ($Answer == "C")
{
//process1
}
else
{
//process2
}

The first problem was in your sql query. the word after select should be the title of a field within the database.

The send thing is that $next_result doesn't really generate the exact field you want.. you have to assign the varialbe after the query with the line below i added.
$Answer=mysql_result($next_result,0,"Answer");

Lastly, as I mentioned above, "$next_result" doesn't work that way so you have to use the new variable you defined, "$Answer" to compare to "C" in your if statment.

hope this helps.
-mike

Anon

Take a look at this part of your code...

if ($next_result == "C")
{
//process1
}
elseif (next_result != "C")
{
//process2
}

in the elseif statement... you are missing the string character($) before 'next_result'
eg. next_result should be $next_result

Hope this helps but without running the code myself it looks fine.
If what i have said above fails you could try writing the if statement as follows...

if ($next_result == "C") {
//process1
}
else{
//process2
}

basically just dont check the string twice but presume that if process 1 isnt run then process 2 must be.

skripty
}

Anon

Thanks Mike, your suggestion worked. You've made me very happy. Cheers again, Sarah.