short form of if else does not update database correctly

[shikra]

$sql_coupon_expire = "SELECT * FROM tbl_coupon";

 

$itm = '[email protected];

$aj = '[email protected]';

$coupon_res = executeQuery($sql_coupon_expire);

 

while($row=mysql_fetch_assoc($coupon_res)){

 

$coupon_update = "UPDATE tbl_coupon SET email = '".($email =($email == $aj)? $itm:$aj)."'";

echo $coupon_update."<br />";

executeQuery($coupon_update);

}

 

The echo output of the query is just fine i.e alternative email is selected but database is updated with only one value... any explanation why?

 

[shikra]

$sql_coupon_expire = "SELECT * FROM tbl_coupon";

 

$itm = '[email protected];

$aj = '[email protected]';

$coupon_res = executeQuery($sql_coupon_expire);

 

while($row=mysql_fetch_assoc($coupon_res)){

 

$coupon_update = "UPDATE tbl_coupon SET email = '".($email =($email == $aj)? $itm:$aj)."'";

echo $coupon_update."<br />";

executeQuery($coupon_update);

}

 

The echo output of the query is just fine i.e alternative email is selected but database is updated with only one value... any explanation why?

need to include the where clause for it to work as desired