<?php
include('includes/config.inc.php');
$_GET['act'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" >
<head>
<title>Admin Panel</title>
<meta http-equiv="Content-type" content="text/html;charset=UTF-8" />
<link rel="stylesheet" type="text/css" media="all" href="style.css" />
<script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"></script>
</head>
<body>
<div id="topbar">Welcome To The GM Panel, <?php echo $_SESSION['Admin']; ?>
<div id="topbar_content">
<ul>
<li><a href="/">Site Home</a></li>
</ul>
</div>
</div>
<div id="outer">
<div id="logonav">
<div id="top_nav">
<ul>
<?php
include('navigation.php');
?>
</ul>
</div>
</div>
<div id="top"></div>
<div id="wrapper">
<div id="body"><p>Guild Name:<BR>
<form method="GET">
<input type='text' name='guild'><BR>
<input type='submit' name='submit' value='Submit' /></form>
<?php
if(isset($_GET['submit'])){
$guild = $_GET['guild'];
mssql_select_db($CharacterDB);
$query = mssql_query("SELECT * FROM [GUILD_TBL] where m_szGuild='$guild'");
while($fetch = mssql_fetch_assoc($query))
{
$guild4 = $fetch['m_idGuild'];
$query2 = mssql_query("SELECT * FROM [GUILD_MEMBER_TBL] WHERE m_idGuild='$guild4'");
$count = mssql_num_rows($query2);
echo "Total Members: ".$count;
while($fetch2 = mssql_fetch_assoc($query2))
{
echo "<center>";
echo "<table border='1' width='70%' style='text-align:center;'>";
echo "<tr>";
echo "<th>Name</th>";
echo "<th>Level</th>";
echo "<th>Penya</th>";
echo "<th>Class</th>";
echo "<th>Guild Leader</th>";
echo "</tr>";
$guildmembers = $fetch2['m_idPlayer'];
$query6 = mssql_query("SELECT * FROM [CHARACTER_TBL] WHERE m_idPlayer='$guildmembers' ");
while($fetch8 = mssql_fetch_assoc($query6))
{
$playerid = mssql_query("SELECT * FROM [CHARACTER_TBL] WHERE m_idPlayer='$guildmembers' ORDER BY m_szName desc");
while($fetchid = mssql_fetch_assoc($playerid))
{
echo "<tr>";
echo '<td rowspan="2"><a href="players.php?act=view&id='.$fetchid['m_idPlayer'].'">'.$fetch8['m_szName'].'</a></td>';
echo "<td rowspan='2'>".$fetch8['m_nLevel']."</td>";
echo "<td rowspan='2'>".$fetch8['m_dwGold']."</td>";
echo "<td rowspan='2'>".$fetch8['m_nJob']."</td>";
$query3 = mssql_query("SELECT * FROM [GUILD_TBL] WHERE m_szGuild='$guild'");
while($fetch3 = mssql_fetch_assoc($query3))
{
$guild2 = $fetch3['m_idGuild'];
$names = $fetchid['m_idPlayer'];
$query4 = mssql_query("SELECT * FROM [GUILD_MEMBER_TBL] WHERE m_idPlayer='$names' ORDER BY m_nMemberLv desc");
while($fetch4 = mssql_fetch_assoc($query4))
{
echo "<td rowspan='2'>";
$level = $fetch4['m_nMemberLv'];
if($level == '0')
{
echo "Leader";
}
elseif($level == '1')
{
echo "Kingpin";
}
elseif($level == '2')
{
echo "Captain";
}
elseif($level == '3')
{
echo "Supporter";
}
elseif($level == '4')
{
echo "Rookie";
}
echo "</td>";
echo "</tr>";
}
}
}
}
echo "</table>";
echo "</center>";
}
}
}
?></p>
<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />
<script type="text/javascript">
var current = "vps";
$(document).ready(function() {
$('.section_controls a').click(function(e) {
if($(this).attr('n') != current) {
var name = $(this).attr('n');
$('#' + current + '_button').removeClass('clicked');
$('#' + current + '_plans').slideUp('fast', function() {
$('#' + name + '_plans').slideDown('fast');
});
$(this).addClass('clicked');
$('#htype').text($(this).attr('title'));
current = $(this).attr('n');
}
});
});
</script>
</div>
</div>
<div id="bottom"><font size='2'>Copyright (c) TeaIXFlyFF</size></div><br />
<div id="footer"><div id="footer_left">PHP By Slash</div><div id="footer_right">Design By Blaze-Games</div></div>
</div>
</body>
</html>
My table shows up like this:
http://i218.photobucket.com/albums/cc158/apixen/Untitled-40.jpg
Any help?
PS: The problem is that the headers come up on every row.
"Name, Level, Class, Penya, and Guild Leader"
Any help please?
