<?php
include('header.php');
$query2 = "select * from gangs";
$display2 = mysql_query($query2);
$row2 = mysql_fetch_array($display2);
$gname2 = $row2['gangname'];
$gangname = $result_ar['gangname'];
$username = $row['username'];
$search2 = mysql_query("select * from '$gangname' where gangmembers = '$username'");
$num_rows = mysql_fetch_array($search2);
echo '<td width="619" height="240" valign="top">';
echo '<table width="85%" height="144" border="1" align="center" bordercolor="#FFFFFF">';
echo '<tr>';
echo '<td height="23"><div align="center"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">:. Record Agencies</font></div></td>';
echo '</tr>';
echo '<tr>';
echo '<td height="74"><p> </p>';
echo '<p><font color="#CCCCCC" size="1" face="Verdana, Arial, Helvetica, sans-serif"><center>';
if ($gangsid != $result_ar['gangname'])
{
echo '<table width="450" border="1" bordercolor="#FFFFFF" font size=1 color="#FFFFFF">';
echo '<tr>';
echo '<td>';
echo '<tr>';
echo '<td><font size=1 color="#FFFFFF"><center><b>:Agency ID:</b></center></font></td>';
echo '<td><font size=1 color="#FFFFFF"><center><b>:Record Agency Name:</b></center></font></td>';
echo '<td><font size=1 color="#FFFFFF"><center><b>:Agency Level:</b></center></font></td>';
echo '</tr>';
$result = mysql_query("SELECT * FROM gangs ORDER BY gangid") or die("error querying database");
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){
echo '<tr>';
echo '<td><font size=1 color="#FFFFFF">';
echo '<center>';
echo $result_ar['gangid'];
echo '</center>';
echo '</font></td>';
echo '<td><font size=1 color="#FFFFFF">';
echo "<a href=\"listrecord.php?gangsid=".$result_ar['gangname']."\">";
echo '<center>';
echo $result_ar['gangname'];
echo '</center></a>';
echo '</font></td>';
echo '<td><font size=1 color="#FFFFFF">';
echo '<center>';
echo $result_ar['ganglevel'];
echo '</center></font></td></tr>';
$i+=1;
}
} else {
echo 'Its Not Set Up Yet But You Still Have Your Agency, Just Check Back Later';
echo '<br><a href="enter.php">[Go Home]</a>';
}
if ($gangsid == $gangname)
{
if ($num_rows > 0)
{
echo 'your in the gang and the pages will be updated later ~Masta D (Administrator)';
} else {
echo 'You are not the owner of this Agency or even a part of so just leave';
}
}
?>
<br>
</td>
</tr>
</table>
</center> </font></p>
<p></p>
<p> </p></td>
</tr>
</table></td>
<?php
include('footer.php');
?>