Display a zero

[kcgame]

Hi, i have a query statement that looks like;

$ibresult=mysql_query("SELECT SUM(Ihouse) FROM incoming WHERE Kno = '$newarray[6]'",$link ) or die(mysql_error());
$buildings=mysql_fetch_array($ibresult);

where my database column (Ihouse column) contains a 0 (zero).
When i print out;

echo"Incoming Houses: ($buildings[0])"; 

It displays Incoming Houses: () 🙁 Instead of

Incoming Houses: (0) <---- which is what i want🙂

Please help, thanks😃

[tsinka]

Hi,

the code should print 0 if the sum is 0. But SUM returns null if no records exist for the given Kno. So try something like this:

$ibresult=mysql_query("SELECT SUM(Ihouse) FROM incoming WHERE Kno = '$newarray[6]'",$link ) or die(mysql_error());
$buildings=mysql_fetch_array($ibresult);

$insum  = (!$buildings[0]) ? 0 : $buildings[0];

echo"Incoming Houses: ($insum)";

Thomas

[nemonoman]

Or just put the logic in the sql:

SELECT IF(SUM(Ihouse) >0,SUM(Ihouse),0)