Useless use of if award
Similar to the useless use of cat award. The useless use of if award highlights code examples where people use the if function or ternary operator when the return of the expression does the exact same thing. I first noticed this with returning boolean values from php functions. To protect the innocent the winner of today’s award will remain anonymous.
<anonymous> to my knowledge, youll have to SUM(IF(your_field <> “”, 1, 0)) as total_non_empty
Ignoring that the whole query should be using where your_field != ” and group by the non if() way to write this is:
SUM(your_field <> ”)
These examples aren’t an award to a specific person since I’m digging them up from my memory. This pretty much applies to both C and PHP.
< ?php
function foo()
{
$str = 'foo';
return $str == 'foo' ? TRUE : FALSE;
}?>
Can be written as
< ?php
function foo()
{
$str = 'foo';
return $str == 'foo';
}?>
I hope this helps you save a few keystrokes when writing code in the future.