operand a database value?

[rendfox]

I'm new to PHP so bear with me.
This is part of some php that checks if an entered "code" is valid, then it sends additional info to a sql database.


I want to check field2 and if the value is "valueB" then goto a different web page. Here's the section of PHP with that "if" statement(line 28). it's not working for me

---------------------------------------------------------------


[PHP]global $ValidateMessage;

$code = $_REQUEST['code'];

if (strlen($code) == 0)
{
$ValidateMessage="";
}
else if (Code_DecodeCode($code) === TRUE)
{
global $gCms;

$db =& $gCms->GetDb();

$code = $db->qstr($_REQUEST['code']);
$field1 = $db->qstr($_REQUEST['field1']);
$field2 = $db->qstr($_REQUEST['field2']);
$field3 = $db->qstr($_REQUEST['field3']);


$sql = "INSERT INTO table SET code=$code, field1=$field1, field2=$field2, field3=$field3;
$db->query($sql);


if (@mysql_affected_rows() == 1)
{

if($field2 == "valueB") {
header("Location: http://www.******");
exit;

} else {

header("Location: http://www.******");
exit;
$ValidateMessage = "Code accepted.";
}

}
else
$ValidateMessage = "$code has already been submitted";
}
else
{
$ValidateMessage = "$code is not valid";
}

echo "$ValidateMessage";[/PHP]

[pbmods]

Heya, RendFox. Welcome to TSDN!

What do you want your code to do? Give an example.
What is your code doing that you don't want it to do? Give an example.
What is your code *not* doing that it is supposed to? Give an example.

[kovik]

This is the actual code? Including the parse error...?

[rendfox]

Hi, thanks guys.

So all the data is being entered into the db fine.
now, if field2 is a radio button and the value is stored as "on", I want to forward the user to a different url.

I thought this line would do it:

if($field2 == "on") {
     header("Location: http://www.******");
    exit;
 

But it's not working for me. The user gets sent to the second url, no matter what the value of field2 is.

I left out the function Code_DecodeCode; don't want to post that. Assume that value === TRUE.

as far as I know, I'm not getting a parse error.

[rendfox]

OK, I threw a

$field2 = $_GET['field2'];
 

in there and it works now.

I guess

$field2 = $db->qstr($_REQUEST['field2']);
 

doesn't hold the variable value in $field2.

[pbmods]

Heya, Rendfox.

Please use CODE tags when posting source code:

[CODE=php]
PHP code goes here.
[/CODE]

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)