Number Format of Query Results

Hello Experts,

Attached is a snipet that sucessfully queries my DB and formats the results.

What I require - modification so that if the reslt is zero, zero is shown. For example, on the first cell, if the result is going to be 0, rather than display 0 kW Hrs, a simple hypen is shown.

Sure this is easy for you guys. Cheers, ArthurStart Free Trial

1:

echo "<td>"  .number_format($sum * $multiplier * 30.42 , 0, '.', ',')."&nbsp;kW Hrs</td><td>$&nbsp;" .number_format($sum * $multiplier * 30.42 * 0.07, 2, '.', ',')."</td><td>$&nbsp;" .number_format($sum * $multiplier * 30.42 * 0.14, 2, '.', ',')."</td></tr>