<? echo $event_name; ?>

'; // izpiši header tabele echo '

List of Registered Players ('.$event_name.')

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $a = "0"; $query = mysql_query("SELECT * FROM prijave WHERE `event_id` = $event_id ORDER BY `time` ASC"); while ( $row = mysql_fetch_array($query) ) { // povečaj števec za ena $a = $a + 1; //določi barvo vrstice, glede na plačano if ($row[paid]== '1') { $color = 'good'; $img = ' Paid

'; } else { $color = "ownz"; $img = ' Still Ownz

'; } $team_id = $row[team_id]; //imenuj team $query1 = mysql_query("SELECT short FROM `team` WHERE id='$team_id'"); //while ( $row1 = mysql_fetch_array($query1) ) { while ( $row1 = mysql_fetch_array($query1) ) { $team = $row1[short]; } //izpiši vrstico echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo "

#	Time	Flag	Team	Nick	Paid?
'.$a.'	'.$row[time].'		'.$team.'	'.$row[nick].'	'.$img.'

"; echo "

"; echo ""; echo ""; //zapri povezavo z bazo mysql_close($baza); } else { echo 'Buzz off you l33t hax0r! Play golf!'; } ?>