How would I do this in PHP?

[jaffer]

hi all.
I need to divide two elements in my array to reach a percentage. Normally this is easy to do but one of the elements is sometimes zero which generates an error message. I'm not sure how to overcome this in PHP.
In SQL I'd do something like this

CASE WHEN $row[sales] <> 0
THEN $row[gp]/$row[sales]
ELSE '0'
END AS gp percent
How would I do this in PHP?

Thanks
BJ -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[stranger]

I think I'can help you, except your data above isn't coming from an array, but anyways:
PHP Code:
<?php if ($row['sales']!=0){
$gp=$row['gp']/$row['sales'];
}
else {$gp=0;} ?>

we still need to change $gp into a percentage...how many decimal places do you want? Here it is rounded to two decimals of a percentage:
PHP Code:
<?php
$gp=round($gp,4);
$gp=$gp*100;
echo $gp . "%";
?> -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[CORMAC]

Just giving you an idea (not checked):
PHP Code:
<?php
foreach($rows as $row)
{
$gp_percent[] = ($row['sales']!=0)?$row['gp']/$row['sales']:0;
}
?>
bye -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[NEILLE]

In fact if you are using mysql you could even do this:
Code:
select
coalesce(gp/sales,0) as gp_percent
from yourtable
the coalesce says that if your result would be null then just show 0 in the gp_percent output. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[TAFFE]

Thanks a lot everyone.
I got it to work, thanks to all your help. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --