if ($conn) { @mysql_select_db('duwopthis_com_-_phpbb') or die("Received this error while selecting database: ".mysql_error()); } $query1 = "SELECT * FROM `phpbb_ranks` WHERE `rank_title`='$team'"; $result1 = mysql_query($query1); if (!mysql_num_rows($result1)) { // If no rows are returned this statement is true die("Query returned nothing...no such $team"); } print ' '; $query = "SELECT * FROM `phpbb_users` ORDER BY `user_id` ASC"; $result = mysql_query($query); for($i = 0; $i < mysql_num_rows($result); $i++) { $query2 = mysql_query("SELECT * FROM `phpbb_ranks` WHERE `rank_id`=" . mysql_result($result,$i,'user_rank3')); $row = mysql_fetch_array($query2); $clan_rank = $row['rank_title']; if (mysql_result($result,$i,'user_rank2') == $rank_needed) { print ""; print ""; print ""; print ""; } } }
Real Name: Rank: Alias:
NA{$query2}" . mysql_result($result,$i,'username') . "