SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Members page

  1. #1
    SitePoint Enthusiast Stika's Avatar
    Join Date
    Sep 2002
    Location
    Australia
    Posts
    33
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Members page

    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">&nbsp;</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">&nbsp; </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">&nbsp;</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">&nbsp; </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($resultMYSQL_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>&nbsp;</p>
    <p>&nbsp;</p>

    also if someone could help clean it up abit for me that would be great

  2. #2
    SitePoint Member panda's Avatar
    Join Date
    Mar 2003
    Location
    Melbourne, Australia
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The link you've given is broken - are you still having the problem?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •