Sql Update statement

[JuicyScript]

Is it possible to have an sql statement like this?
With the if condition statement in between

$sqlQuery = "UPDATE `members` SET
if ($basic = english)
`basic` = '".$basic."',
else
`basic` = '""',
endif;
`school` = '".$school."'
WHERE `member_id` =
".$_SESSION['SESS_MEMBER_ID'];
$result = mysql_query($sqlQuery) or die(mysql_error());

[LifeinAsia]

You'll need an AND in there (between the `basic` = and `school` = parts).

[rocknbil]

It would be simpler to do it programmatically.

$basic=($basic=='english')?$basic:'';
// or better yet, case insensitive
// $basic=(preg_match('/english/i',$basic))?$basic:'';
$sqlQuery = "UPDATE `members` SET `basic` = '$basic', `school` = '$school' WHERE `member_id` = ".$_SESSION['SESS_MEMBER_ID'];

Note that concatenation is not needed with $scalar_variables.

[LifeinAsia]

(And ignore my previous message- didn't have enough coffee in my yet and I mis-read the statement...)

[JuicyScript]

hello rocknbil
i knw this section is not php but what i what to do is to compare the variable with the field name and if they match it is inserted in the database else nothing is inserted

$basic=($basic=='english')?$basic:'';
// or better yet, case insensitive
// $basic=(preg_match('/english/i',$basic))?$basic:'';
$sqlQuery = "UPDATE `members` SET `basic` = '$basic', `school` = '$school' WHERE `member_id` = ".$_SESSION['SESS_MEMBER_ID'];

[rocknbil]

See your post in PHP - I *think* I got what you wanted there. :-)