I have a members page here
and it shows up my members, but it dosent show details
here is the code
PHP Code:<?
// Syndicate Members Page
// Started a few weeks ago (Current Date: August 21st 2002)
if (!isset($id)): ?>
<body bgcolor="c0c0c0">
<table width="304" bgcolor="#c0c0c0" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="17" width="300" colspan="3"></td>
</tr>
<tr>
<td width="300" colspan="3" height="17"> </td>
</tr>
<tr>
<td width="300" colspan="3">
<div align="center"> <b><font size="3">Counter-Strike</font></b><br>
<b>Division</b><br>
<img src="images/site/icons_cs.gif" width="40" height="40"> <br>
<?
require_once('more_conf.php');
mysql_select_db($db_name, $db);
//definine table sections here
// Counter Strike
$cs_listquery = "SELECT * FROM members WHERE division = 'cs' or division = 'both' ORDER BY rank";
$cs_list = mysql_query($cs_listquery, $db) or die(mysql_error());
$cs_num_results = mysql_num_rows($cs_list); //Row Count
for ($i=0; $i <$cs_num_results; $i++)
{
$csrow = mysql_fetch_assoc($cs_list);
$csrowid = $csrow["id"];
$csrowgamename = $csrow["gamename"];
echo "<a href='?loc=members&id=$csrowid'>$csrowgamename</a><br>";
}
mysql_free_result($cs_list);
?>
</div>
</td>
</tr>
<tr>
<td width="300" colspan="3" height="17"> </td>
</tr>
<tr>
<td height="17" background="images/site/bottom_1.gif" width="130"></td>
<td height="17" background="images/site/bottom_2.gif" width="146"></td>
<td height="17" background="images/site/bottom_3.gif" width="28"></td>
</tr>
</table>
</body>
<body bgcolor="c0c0c0">
<table width="304" bgcolor="#c0c0c0" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="17" width="300" colspan="3"></td>
</tr>
<tr>
<td width="300" colspan="3" height="17"> </td>
</tr>
<tr>
<td width="300" colspan="3">
<div align="center"> <b><font size="3">Natural Selection</font></b><br>
<b>Division</b><br>
<img src="images/site/icons_ns.gif" width="40" height="40"> <br>
<?
require_once('more_conf.php');
mysql_select_db($db_name, $db);
// Natural Selection
$cs_listquery = "SELECT * FROM members WHERE division = 'ns' or division = 'both' ORDER BY rank";
$cs_list = mysql_query($cs_listquery, $db) or die(mysql_error());
$cs_num_results = mysql_num_rows($cs_list); //Row Count
for ($i=0; $i <$cs_num_results; $i++)
{
$csrow = mysql_fetch_assoc($cs_list);
$csrowid = $csrow["id"];
$csrowgamename = $csrow["gamename"];
echo "<a href='?loc=members&id=$csrowid'>$csrowgamename</a><br>";
}
mysql_free_result($cs_list);
?>
</div>
</td>
</tr>
<tr>
<td width="300" colspan="3" height="17"> </td>
</tr>
<tr>
<td height="17" background="images/site/bottom_1.gif" width="130"></td>
<td height="17" background="images/site/bottom_2.gif" width="146"></td>
<td height="17" background="images/site/bottom_3.gif" width="28"></td>
</tr>
</table>
</body>
<? else: ?>
<?
require_once('more_conf.php');
mysql_select_db($db_name, $db);
$result = mysql_query("SELECT * FROM members WHERE id = $id");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$gamename = $row['gamename'];
$userpass = $row['userpass'];
$username = $row['username'];
$division = $row['division'];
$location = $row['location'];
$email = $row['email'];
$icq = $row['icq'];
$wonid = $row['wonid'];
$map = $row['map'];
$name = $row['name'];
$age = $row['age'];
$rank = $row['rank'];
$website = $row['website'];
// CS Specific
$cs_primary_weapon = $row['cs_primary'];
$cs_secondary_weapon = $row['cs_secondary'];
$server = $row['server'];
$team = $row['team'];
$hours = $row['hours'];
$time = $row['time'];
// NS Specific
$ns_primary_weapon = $row['ns_primary'];
$ns_server = $row['ns_server'];
$ns_team = $row['ns_team'];
$ns_map = $row['ns_map'];
}
mysql_free_result($result);
?>
<body bgcolor="c0c0c0">
<table width="304" bgcolor="c0c0c0" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="300" colspan="3">
<div align="right">
<p align="center"><font size="6">
<? echo $gamename; ?>
</font> <br>
<img src="images/site/news_300_break.gif" width="304" height="7"><br>
</div>
<table width="200" bgcolor="c0c0c0" cellspacing="0" cellpadding="0" align="center" border="0">
<tr>
<td width="33%">
<div align="right"><a href="http://wwp.icq.com/scripts/search.dll?to=<? echo $icq; ?>"><img src="images/site/icons_icq.gif" width="15" height="16" border="0"></a></div>
</td>
<td width="33%">
<div align="center"><b><img src="images/site/icons_cs.gif" width="23" height="23"></b></div>
</td>
<td width="33%">
<div align="left"><a href="mailto:<? echo $email; ?>"><img src="images/site/icons_email.gif" width="15" height="16" border="0"></a></div>
</td>
</tr>
</table>
<div align="center">
<?
if ($division == "cs")
{
?>
<BR><BR><b>::Minor Details::</b><BR>
<b>Name:</b> <? echo $name; ?> <BR>
<b>Age:</b> <? echo $age; ?> <BR>
<b>Rank:</b> <? echo $rank; ?> <BR>
<b>Location:</b> <? echo $location; ?> <BR>
<b>Personal Site:</b> <a href="<? echo $website; ?>"><? echo $website; ?></a> <BR><BR>
<b>::Counter-Strike::</b><BR>
<b>Favourite Weapon:</b> <? echo $cs_primary_weapon; ?> <br>
<b>Favourite Handgun:</b> <? echo $cs_secondary_weapon; ?><br>
<b>Favourite Server:</b> <? echo $server; ?><BR>
<b>Favourite Team:</b> <? echo $team; ?><BR>
<b>Average hours A week playing <? echo $division; ?>:</b> <? echo $hours; ?><BR>
<b>Have been playing <? echo $division; ?> for how long:</b> <? echo $time; ?><BR>
<b>Favourite Map:</b> <? echo $map; ?><br>
</div>
<div align="center">
<?
if ($division == "ns")
{
?>
<BR><BR><b>::Minor Details::</b><BR>
<b>Name:</b> <? echo $name; ?> <BR>
<b>Age:</b> <? echo $age; ?> <BR>
<b>Rank:</b> <? echo $rank; ?> <BR>
<b>Location:</b> <? echo $location; ?> <BR>
<b>Personal Site:</b> <a href="<? echo $website; ?>"><? echo $website; ?></a> <BR><BR>
<b>::Natural Selection::</b><BR>
<b>Favourite Weapon:</b> <? echo $ns_primary_weapon; ?> <br>
<b>Favourite NS Server:</b> <? echo $ns_server; ?><BR>
<b>Favourite Team:</b> <? echo $team; ?><BR>
<b>Average hours A week playing NS:</b> <? echo $hours; ?><BR>
<b>Have been playing NS for how long:</b> <? echo $time; ?><BR>
<b>Favourite Map:</b> <? echo $map; ?><br>
</div>
<div align="center">
<?
if ($division == "both")
{
?>
<BR><BR><b>::Minor Details::</b><BR>
<b>Name:</b> <? echo $name; ?> <BR>
<b>Age:</b> <? echo $age; ?> <BR>
<b>Rank:</b> <? echo $rank; ?> <BR>
<b>Location:</b> <? echo $location; ?> <BR>
<b>Personal Site:</b> <a href="<? echo $website; ?>"><? echo $website; ?></a> <BR><BR>
<b>::Counter-Strike::|::Natural Selection::</b><BR>
<b>Favourite CS Weapon:</b> <? echo $cs_primary_weapon; ?><br>
<b>Favourite CS Handgun:</b> <? echo $cs_secondary_weapon; ?><br>
<b>Favourite NS Weapon:</b> <? echo $ns_primary_weapon; ?><br>
<b>Favourite CS Server:</b> <? echo $server; ?><BR>
<b>Favourite NS Server:</b> <? echo $ns_server; ?><BR>
<b>Favourite CS Team:</b> <? echo $team; ?><BR>
<b>Favourite NS Team:</b> <? echo $ns_team; ?><BR>
<b>Average hours A week playing CS & NS:</b> <? echo $hours; ?><BR>
<b>Have been playing CS & NS for how long:</b> <? echo $time; ?><BR>
<b>Favourite CS Map:</b> <? echo $map; ?><br>
<b>Favourite NS Map:</b> <? echo $ns_map; ?><br>
</div>
<br>
</td>
</tr>
</table>
</body
<?php }}}
endif; ?>
<p> </p>
<p> </p>
also if someone could help clean it up abit for me that would be great
Bookmarks