Hi all,
<?php
$sql= "SELECT
CASE WHEN prize_winners_no > 2110 THEN 'No prize 😢'
WHEN (prize_winners_no -10) % 6 = 0 THEN 'Prize A!!'
WHEN (prize_winners_no -10) % 3 = 0 THEN 'Prize B!'
ELSE 'No prize 😢'
END AS prize"
?>
The above would not work on MySQL Because the modulus operator '%' is not ANSI-SQL, I think it only works on SQL Server or Oracle, perhaps I should be using mod().
Can anyone tell me how to make the above code PHP/MySQL compliant?
Thanks
