Untitled

<?php
include("scripts/login.php");
include("includes/header1.inc");
?>
<title>Syndicate Jailers - Edit</title>
<?php include("includes/header2.inc"); ?>

<body>
<?php
$tag=$_GET['tag'];
$loc="localhost";
$username="ltaradio_sj1";
$password="123";
$database="ltaradio_sj1";
$link = mysql_connect($loc,$username,$password);
mysql_connect($loc,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM members WHERE tag='$tag'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$tag=mysql_result($result,$i,"tag");
$email=mysql_result($result,$i,"email");
$points=mysql_result($result,$i,"points");
$referral=mysql_result($result,$i,"referral");
$age=mysql_result($result,$i,"age");
$rank=mysql_result($result,$i,"rank");
$active=mysql_result($result,$i,"active");
$avatar=mysql_result($result,$i,"avatar");

if ($active == 0) {
$status = '<font color="yellow">Pending</font>';
}
elseif ($active == 1) {
$status = '<font color="green">Active</font>';
}
elseif ($active == 2) {
$status = '<font color="red">Suspended</font>';
}
}
?>
<?php include("includes/header3.inc"); ?>
                    <div class="main_news_con">
                          <div class="main_news_post">
                          <div class="main_news_post_img">
                              <img src="images/news_post_img.jpg" alt="" />
                            </div>
                            <div class="main_news_post_text_con">
                              <div class="main_news_post_text_details">
                                  <div class="main_news_post_text_title">
                                      <a href="#">Edit Profile</a></div>
                                    <div class="main_news_post_text_date">
                                      2/7/2011</div>
                                    <div class="main_news_post_text_comments">
                                      Posted by Alex</div>
                                    <div class="clr"></div>
                                </div>
                                <div class="main_news_post_text">
                                  <p>

      <form action="scripts/edit.php" method="post">
                <table width="" align="" style="border-collapse: collapse;">
<?php echo "
                <tbody>
    <tr>
      <td>GamerTag<br />
        </td>
      <td> $tag
    <input type='hidden' value='$tag' name='ud_tag' /> <br />
        </td>
    </tr>
    <tr>
      <td>Email Address<br />
        </td>
      <td><input type='text' name='ud_email' value='$email'><br />
        </td>
    </tr>
    <tr>
      <td>Gamer Points<br />
        </td>
      <td><input type='text' name='ud_points' value='$points'><br />
        </td>
    </tr>
    <tr>
      <td>Referral<br />
        </td>
      <td> $referral <input type='hidden' value='$referral' name='ud_referral'><br />
        </td>
    </tr>
    <tr>
      <td>Age<br />
        </td>
      <td><input type='text' name='ud_age' value='$age'><br />
        </td>
    </tr>
    <tr>
      <td>Rank<br />
        </td>
      <td>$rank <input type='hidden' value='$rank' name='ud_rank'><br />
        </td>
    </tr>
    <tr>
      <td>Status<br />
        </td>
      <td> $status <input type='hidden' value='$status' name='ud_status'><br />
        </td>
    </tr>
    <tr>
      <td>Avatar<br />
        </td>
      <td><input type='text' name='ud_email' value='$avatar'> <br />
        </td>
    </tr>
    <tr>
      <td style=\"\" colspan=\"1\">Password (Must enter)<br />
        </td>
      <td style=\"\" colspan=\"1\"><input type='text' name='ud_password' ></td>
    </tr>
  </tbody>
</table> </form> "; ?>
       <br />
                    </p>
                                </div>
                            </div>
                            <div class="clr"></div>
                        </div>
                    </div>
                </div>
               <?php include("includes/sidebar.inc"); ?>
                </div>
                <div class="clr"></div>
            </div>

                <?php include("includes/footer.inc"); ?>
                <div class="clr"></div>
            </div>
        </div>
    </div>
</div>
</body>
</html>