rendered paste body 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 '
<table width="757" border="1">
<tr>
<td>Real Name:</td>
<td>Rank:</td>
<td>Alias:</td>
</tr>';
$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 "<tr>";
print "<td>NA</td>";
print "<td>{$query2}</td>";
print "<td>" . mysql_result($result,$i,'username') . "</td>";
}
}
}