Division and PHP

[dpalame]

I am using the following code:

 

$sales=$row[wfdollarsales];

$sales = preg_replace("/[^a-zA-Z0-9\s]/", "", $sales);

$sales = intval($sales);

$salesly=$row[wfdollarsalesly];

$salesly = preg_replace("/[^a-zA-Z0-9\s]/", "", $salesly);

$salesly = intval($salesly);

$subtraction=$sales-$salesly;

$percent=$subtraction/$salesly;

 

The $subtraction works fine, but $percent keeps returning "Warning: Division by zero in:".  Can somebody tell me what I am doing wrong?  Thanks

[jcbones]

Try adding de-bugging to see where you are going wrong.

 

$sales=$row[wfdollarsales];
echo 'Sales starts as:' . $sales . '<br />';
   $sales = preg_replace("/[^a-zA-Z0-9\s]/", "", $sales);
echo 'After preg_replace, it is now: ' . $sales . '<br />';
   $sales = intval($sales);
   $salesly=$row[wfdollarsalesly];
echo 'Salesly starts as: ' . $salesly . '<br />';
   $salesly = preg_replace("/[^a-zA-Z0-9\s]/", "", $salesly);
echo 'After preg_replace it is now: ' . $salesly . '<br />';
   $salesly = intval($salesly);
   $subtraction=$sales-$salesly;
echo 'Sales minus Salesly = ' . $subtraction . '<br />';
   $percent=$subtraction/$salesly;
echo 'Subtraction divided by salesly = ' . $percent . '<br />';

 

Using that, I think you will see where you are going wrong.

[dpalame]

Thank you that was very helpful.  Made me realize I had 0s in the data.  Added $percent=@($subtraction/$salesly)*100; for the rows that contain 0.  Thank you again for your help.