Please help with this mysql script

[leocrawf]

I am trying to get a mysql script to evaluate a piece of data then assign
a value base on the result here is what i have so far:

for($i=0;$i<=$x;$i++){
$addmerchants = "insert into myp_compare_merchants_cmt 
(idcmr_cmt,idmrt_cmt,value_cmt) values ('$id_cmr',
'$merchantid[$i]','if($merchantid[$i]<>0,'1','0')')";
$addmerchants = mysql_query($addmerchants) or die(mysql_error());
}

everything works except this part:
'if($merchantid[$i]<>0,'1','0')'

Any idea how to do this you all. Thanks in advance.

[hassanvoyeau]

you can use a variable

e.g. $value = if($merchantid[$i]<>0,'1','0');

and then add $value to your sql statement

[leocrawf]

ok that looks like it can work. Thanks a million.

[owen]

plus thats just a nasty way to code. PHP only evaluates variables in strings. It won't see the IF statement.

[Utech22]

you can use a variable

e.g. $value = if($merchantid[$i]<>0,'1','0');

and then add $value to your sql statement

This was what I had in mind also, because sql don't do such evaluation.