Hello once again. I am trying to make a simple member system for my clan site. If you would please take a moment to view my site (
http://www.clanadvanced.com) and see how simple indeed the member system is.
Now, the whole script works just fine and dandy except for one part, please take a look at
this page to see what i mean. I need this to be like the members list on the site if you know what i mean, lol.
Here are my 2 pages.
AddMember.php
Code:
<?php
include('session_vars.php');
// Check to see if they are logged in..
if ($enpw != $pw){
header("Location: ../ad_login.php");}
else if(!$action){
?>
<BODY background="../images/image_22.gif" OnLoad="self.focus();document.addmember.name.focus()">
<div align="center">
<br><a href="#" target="iframe" title="Remove Member(s)">Remove Member(s)</a>
<br><br>
<FORM ACTION="?action=submit" method="POST" name="addmember">
<TABLE width="80%" valign="center">
<tr bgcolor="#CCCCCC">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
Member Name: </td>
<td><INPUT type="text" name="member" tabindex="1" size="30"></td>
</tr>
<br><br>
<tr bgcolor="#EEEEEE">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
Rank: </td>
<td>
<select name="rank">
<option value="Member">Member</option>
<option value="Senior Member">Senior Member</option>
<option value="Council">Council</option>
</select>
</td>
</tr>
</TABLE>
<TABLE width="80%" valign="center">
<tr bgcolor="#CCCCCC">
<td><center>
<INPUT type="submit" tabindex="5" name="submit" value="Add Member">
</center></td>
</tr>
</TABLE>
</FORM>
<br><br>
[<a href="Loggedin.php" target="iframe"> Back to Admin CP </a>]
<br>
<a href="../members.php" target="iframe">Members List</a>
</div>
<?php
}else if($action == "submit") {
include('mysql_connect.php');
if(empty($member)) exit("Please Select a Rank and provide a Member to Add");
// add slashes
$member = addslashes($member);
// add data into database
mysql_query("INSERT INTO members (member,rank) VALUES ('$member','$rank')") or die(mysql_error());
echo "Successfully Added $member as $rank<br><br><a href=\"Loggedin.php\" target=\"iframe\">Return to the Admin Panel</a>";
}
?>
members.php
Code:
<html>
<head>
<title>Members List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
<!--
a{text-decoration:none}
//-->
</style>
<style>
a:link{color:orange; text-decoration:underline; }
a:hover{color:orange; text-decoration:underline; }
</style>
</head>
<BODY BGCOLOR=#332815 background="images/image_22.gif" link="#000000" vlink="#F00000" bgproperties="fixed" LEFTMARGIN=2 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<?php
include('admincp/mysql_connect.php');
$query = mysql_query('SELECT * FROM members ORDER BY id DESC');
while($row = mysql_fetch_object($query)) {
$rank = $row->rank;
$name = $row->member;
if($rank == "Member") {
$member_list = $name;}
else if($rank == "Senior Member") {
$senior_list = $name;}
else if($rank == "Council") {
$council_list = $name;}
?>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Members List</font></b></td>
</tr>
<tr>
<td bgcolor="#F5F5F5">
<table align="center" width="100%" border="0">
<tr>
<td align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><br>
<u><b>Leader and Founder</b></u><br>Dahnkuana[aD]
<br><br>
<u><b>Council</b></u><br>
<?php echo $council_list; ?><br>
<br><br>
<u><b>SeniorMembers</b></u><br>
<?php echo $senior_list; ?><br>
<br><br>
<u><b>Members</b></u><br>
<?php echo $member_list; ?><br>
<br><br>
</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<?php
}
?>
Can someone please tell me what i'm doing wrong?