include ("forms/conn.php"); for ( $counter = 1; $counter <= 29; $counter += 1) { $cluestring = $cluestring . "clue" . $counter. ", ";} $cluestring = $cluestring . "clue30"; $query="SELECT user_name, bonus, $cluestring FROM users WHERE bonus > 0 and id > 69 ORDER BY bonus DESC"; $result=mysql_query($query); if(mysql_num_rows($result) != 0) { $count = 1; echo ("\t
| Nick | \n\t\t\t\t"); for ( $counter = 1; $counter <= 30; $counter += 1) { echo ("Round " . $counter . " Score | \n\t\t\t\t"); }
echo ("Bonus Score | \n\t\t\t
|---|---|---|
| " . str_replace(" ", " ", $name) . " | \n");
for ( $counter = 1; $counter <= 30; $counter += 1) {
$currentround = $clue[$counter];
if ($currentround == "1209077999") $dark = " class=\"dark\""; else $dark = "";
echo ("\t\t\t\t" . $currentround . " | \n"); } echo ("\t\t\t\t" . $bonus . " | \n\t\t\t