problem with dont know what..
Posted: Sat Feb 14, 2004 10:51 am
This script prints error: Division by zero...
or <TD>000000000000000000000-2</TD>.. in source code of page. But none of these value is 0.
or <TD>000000000000000000000-2</TD>.. in source code of page. But none of these value is 0.
Code: Select all
for ($i=1; $i<5; $i++) {
print "<TR align=center><TD>$i</TD>";
print "<TD>";
$sql="SELECT COUNT(status) from typy where stawka=$i AND status NOT LIKE 'pending'";
$wynik = mysql_query($sql) or die(sql_error);
while ($row = mysql_fetch_row($wynik)) {
$all=$row[0];
print $all;
}
print "</TD><TD>";
$sql="SELECT COUNT(status) from typy where stawka=$i AND status like 'win'";
$wynik = mysql_query($sql) or die(sql_error);
while ($row = mysql_fetch_row($wynik)) {
$win=$row[0];
print $win;
}
print "</TD><TD>";
$skut=($win/$all*100);
print round($skut,2)."%";
}
print "</TD><TD>";
$sql_moc="SELECT SUM(kurs*stawka) from typy where stawka=$i AND status like 'win'";
$wynik = mysql_query($sql_moc) or die(sql_error);
while ($row = mysql_fetch_row($wynik)) {
$wygrana=round($row[0],2);
}
$sql="SELECT SUM(stawka) from typy where stawka=$i";
$wynik = mysql_query($sql) or die(sql_error);
while ($row = mysql_fetch_row($wynik)) {
$wklad=$row[0];
}
$prof=($wygrana-$wklad);
print $prof;
print "</TD><TD>";
if ($wklad==0 || $wygrana==0)
{
print "0%";
}
else {
$zysk=(($wygrana/$wklad)*100-100);
print round($zysk,2)."%";
}
print "</TD></TR>";
}