zero in the denominator

[tjbarr]

In the code below, I would like to make a condition that if the denominator : .$table2.".".$pre2.$yr_array[$j].") is equal to zero or a negative number then I want the answer to the equation to be 0 or "zero". Can't get the code right.

$strSQL=$strSQL."(".$table.".".$pre.$yr_array[$j]."/".$table2.".".$pre2.$yr_array[$j].") as " .$newpre.$yr_array[$j];

[bad76]

Hi,
you can try to look the manual for select IF(expr1,expr2,expr3);

It return expr2 if expr1 is true, else expr3.

So you can try this:

$strSQL=$strSQL."IF( (".$table2.".".$pre2.$yr_array[$j].">0),(".$table.".".$pre.$yr_array[$j]."/".$table2.".".$pre2.$yr_array[$j]."), ('zero')) as " .$newpre.$yr_array[$j];

But i never use it first...