\n";
$score_nr=0;
$result_p = mysql_query("SELECT idx,title,level,score FROM pinballs WHERE idx>=100 and idx<200 ORDER BY idx");
while ($res_p = mysql_fetch_array($result_p)) {
if ($res_p["score"]=="Grand Champion") {
$query="SELECT typ,p_idx,score_billions,score_units,datum,showinfo,player,email,www,zusatz from scores LEFT JOIN players ON scores.p_idx=players.idx WHERE typ=".$res_p["idx"]." ORDER BY score_billions DESC,score_units DESC";
$result = mysql_query("$query");
$resarray = mysql_fetch_array($result);
echo "\n";
echo " |
\n";
echo "\n";
mysql_free_result($result);
}
$query="SELECT typ,p_idx,score_billions,score_units,datum,showinfo,player,email,www,zusatz from scores LEFT JOIN players ON scores.p_idx=players.idx WHERE typ=".$res_p["idx"]." ORDER BY score_billions DESC,score_units DESC";
$result = mysql_query("$query");
if ($score_nr>0) {
if (($score_nr/2)==floor($score_nr/2)) {
echo " |
|
\n";
} else
echo " | | \n";
}
$score_nr=$score_nr+1;
echo "\n";
mysql_free_result($result);
}
mysql_free_result($result_p);
echo " |
\n";
?>