Problema Division by zero

guadagnaeuro

Problema Division by zero

Buongiorno a tutti

Chiedo un aituo per una formula php che in alcuni casi da risultato 0 e mi da un errore "Division by zero".

Posto il codice per favore potete aiutarmi a risolvere il problema?

Grazie a tutti per aiuto

Buonasera

[php]

$click_active_bought=mysql_fetch_assoc(mysql_query("SELECT (SUM(plan)) AS total_click_active_bought FROM yob_ads WHERE user <> 'admin' AND ads_category = 'click' AND status = 'active'"));
$click_active_sent=mysql_fetch_assoc(mysql_query("SELECT (SUM(members)) AS total_click_active_sent FROM yob_ads WHERE user <> 'admin' AND ads_category = 'click' AND status = 'active'"));
$click_active_available=mysql_fetch_assoc(mysql_query("SELECT (SUM(plan-members)) AS total_click_active_available FROM yob_ads WHERE user <> 'admin' AND ads_category = 'click' AND status = 'active'"));

<tr>
<th width="250">Total Click Active Sold</th>
<td> <?php echo $click_active_bought[total_click_active_bought]; ?> (<?php echo round(($click_active_bought[total_click_active_bought]/$click_active_bought[total_click_active_bought]*100),2); ?>%) </td>
</tr>
<tr>
<th width="250">Total Click Active Sent</th>
<td> <?php echo $click_active_sent[total_click_active_sent]; ?> (<?php echo round(($click_active_sent[total_click_active_sent]/$click_active_bought[total_click_active_bought]*100),2); ?>%) </td>
</tr>
<tr>
<th width="250">Total Click Active Available</th>
<td> <?php echo $click_active_available[total_click_active_available]; ?> (<?php echo round(($click_active_available[total_click_active_available]/$click_active_bought[total_click_active_bought]*100),2); ?>%) </td>
</tr>

[/php]

thedarkita

Ciao guadagnaeuro,

dovresti fare in modo che $click_active_bought[total_click_active_bought] abbia come valore minimo 1.
[php]
if($click_active_bought[total_click_active_bought] == 0)
$click_active_bought[total_click_active_bought] = 1;
[/php]