טוב אז הנה הקוד שכתבתי, המליצו לי בבקשה על שיפורים :
PHP קוד:
<?php
include ("db.php");
$op1= mysql_query("SELECT votes FROM poll WHERE votes=1");
$a=mysql_num_rows($op1);
$op2= mysql_query("SELECT votes FROM poll WHERE votes=2");
$b = mysql_num_rows($op2);
$op3= mysql_query("SELECT votes FROM poll WHERE votes=3");
$c= mysql_num_rows($op3);
$op4= mysql_query("SELECT votes FROM poll WHERE votes=4");
$d = mysql_num_rows($op4);
$numofvotes= mysql_query("SELECT votes FROM poll");
$num = mysql_num_rows($numofvotes);
$sa= $a / $num;
$sa *= 100;
$sa=round($sa*1);
$wid=(int)$sa;
$sb = $b / $num;
$sb *= 100;
$sb=round($sb*1);
$wid2=(int)$sa;
$sc = $c / $num;
$sc *= 100;
$sc = (int)$sc;
$sc=round($sc*1);
$wid3=(int)$sa;
$sd = $d / $num;
$sd *= 100;
$sd = (int)$sd;
$sd=round($sd*1);
$wid4=(int)$sa;
$plus=$sa+$sb+$sc+$sd;
$last=100-$plus;
$o=$sd+$last;
echo "<table width=100 height=100 border=1>
<tr><td><div align=right>
<table width=$wid>
<tr><td border=1 bgcolor=red>
<Center><font size=1 face=arial color=white>$sa%</font></td></tr>
</table>
<table width=$wid2>
<tr><td bgcolor=red>
<Center><font size=1 face=arial color=white>$sb%</font></td></tr>
</table>
<table width=$wid3>
<tr><td bgcolor=red>
<Center><font size=1 face=arial color=white>$sc%</font></td></tr>
</table>
<table width=$wid4>
<tr><td border=1 bgcolor=red>
<Center><font size=1 face=arial color=white>$o%</font></td></tr>
</table>
</td></tr></table>
";
?>