include ("funcs.inc.php");
connect();
$titel="Die Top 10 Witze";
$htitel="Die Top 10 Witze";
include ("header.inc.php");
?>
| Platz | Witz | Note |
$i=0;
$erg=mysql_query("SELECT witz,note,votes FROM witze WHERE votes<>0 ORDER BY (note/votes) LIMIT 0,10");
while ($row=mysql_fetch_row($erg))
{
$i++;
$witz=$row[0];
$note=$row[1];
$votes=$row[2];
if ($bgcolor=="fffbda")
{
$bgcolor="fffce0";
}
else
{
$bgcolor="fffbda";
}
if ($votes<>0)
{
$note=($note/$votes);
}
echo '
| '.$i.'. | '.$witz.' | '.($votes<>0?colorize($note,$noten_text[$note-1])." (".komma($note).")":"noch keine").' |
';
}
?>
include ("footer.inc.php");
?>