Jump to content

if statement


eMonk

Recommended Posts

The following code works but wondering if I should be using $update1, $update2, $rsUpdate1, $rsUpdate2 instead for error checking etc.

 

$update = "UPDATE model SET name = '$name', age = '$age', ... ";
$rsUpdate = mysql_query($update);

if( isset($city_1) )
{
$update = "UPDATE model_in_city SET city_id = '$city_1', ...'";
$rsUpdate = mysql_query($update);
}

if( isset($city_2) )
{
$update = "UPDATE model_in_city SET city_id = '$city_2', ...'";
$rsUpdate = mysql_query($update);
}

if ($rsUpdate) // insert $rsUpdate2 && $rsUpdate3 here as well?
{
echo "Update successful.";
}

 

Link to comment
Share on other sites

variable scope is involved here. since you declare both $update and $rsUpdate outside of any statements...when you declare them again in your if statements you are writing over them....the best practice would be to change the variables like you have in your initial question text

Link to comment
Share on other sites

if you require that all three to be set, then you would use

if ($rsUpdate1 && $rsUpdate2 && $rsUpdate3)
{
echo "Update successful.";
}

else you can use

[code]if ($rsUpdate1 || $rsUpdate2 || $rsUpdate3)
{
echo "Update successful.";
}

[/code]

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.