I'm kinda n00b to the whole php/mysql thing but I shouldnt think it would be to hard You could make a MySQL database to to cover information for both the roster and matches, Ive included some code example below for creating the roster and members page. Goodluck with making this, feel free to send me some finished code lol Note that these pages are NOT secure and that you will need to incorporate some sort of login to secure them. Create Database named 'clanwar' through MySQL then run following SQL Query [code]CREATE TABLE `matches` ( `opponent` varchar(30) NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', `maps` varchar(50) NOT NULL default '', `score` varchar(10) NOT NULL default '' ) TYPE=MyISAM; [/code] [code]CREATE TABLE `members` ( `id` int(4) NOT NULL auto_increment, `user` varchar(25) NOT NULL default '', `firstname` varchar(15) NOT NULL default '', `lastname` varchar(15) NOT NULL default '', `position` varchar(15) NOT NULL default '', `email` varchar(30) NOT NULL default '', `rank` varchar(15) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=5; [/code] next a file to hold our MySQL details in, create private.inc.php with following code: [code]<? $username="root"; //MySQL username $password="pass"; //MySQL passwrd $database="clanwar"; //MySQL database name ?>[/code] next a script to insert the details into the database, create insert.php with following code note that I havent included a redirect at the bottom because well I couldnt remember the code for that lol [code]<html> <head> <title>Roster - Insert Details</title> <meta http-equiv="Content-Type" content="text/html; charset=unicode"> <meta name="keywords" content="test page"> <link rel=StyleSheet href="style.css" type="text/css"> </head> <? /* This script written by raVest. Created on the 26/04/2006 Website: http://ravestyles.com Member management system with backend for the creation, updating and deletion of users from a MySQL database. Please contact raVest if you have any concerns or isses on trance@ravestyles.com */ include("private.inc.php"); $user=$_POST['user']; $firstname=$_POST['firstname']; $lastname=$_POST['lastname']; $position=$_POST['position']; $email=$_POST['email']; $rank=$_POST['rank']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query = "INSERT INTO members VALUES ('','$user','$firstname','$lastname','$position','$email','$rank')"; mysql_query($query); mysql_close(); ?>[/code] And also a page to input these details from, signup.html [code]<html> <head> <title>Signup Page</title> <meta http-equiv="Content-Type" content="text/html; charset=unicode"> <meta name="keywords" content="test page"> <link rel=StyleSheet href="style.css" type="text/css"> </head> <font class="itext"> <form action="insert.php" method="post"> Username: <input type="text" name="user"><br> First Name: <input type="text" name="firstname"><br> Last Name: <input type="text" name="lastname"><br> Clan Position: <input type="text" name="position"><br> E-mail: <input type="text" name="email"><br> <label for="rank">Rank:</label> <select name="rank" id="rank"> <option selected value="Choose One">Choose One... <option value="Administrator">Administrators <option value="Channel Admin">Channel Admin <option value="Members">Members <option value="Trial">On Trial </select><br> <input type="Submit"> </form> </font>[/code] then we can output all the info onto a roster, this is a basic page which just lists the info from the database, I havent built up a table to display it how u would like but you can play around with this. Create roster.php with following code: [code]<html> <head> <title>Roster (Members and Admins)</title> <meta http-equiv="Content-Type" content="text/html; charset=unicode"> <meta name="keywords" content="test page"> <link rel=StyleSheet href="style.css" type="text/css"> </head> <? /* This script written by raVest. Created on the 26/04/2006 Website: http://ravestyles.com Member management system with backend for the creation, updating and deletion of users from a MySQL database. Please contact raVest if you have any concerns or isses on trance@ravestyles.com */ include("private.inc.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM members"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<font class=ihead><center>Roster [<a href=signup.php>Add member</a>]</center></font><br><br>"; $i=0; while ($i < $num) { $user=mysql_result($result,$i,"user"); $firstname=mysql_result($result,$i,"firstname"); $lastname=mysql_result($result,$i,"lastname"); $position=mysql_result($result,$i,"position"); $email=mysql_result($result,$i,"email"); $rank=mysql_result($result,$i,"rank"); echo "<font class=itext>Player Name:$user<br>Real Name: $firstname $lastname<br>Position: $position<br>Email: $email<br>Rank: $rank<br></font><hr><br>"; $i++; } ?>[/code] Heres a stylesheet to use with it as well for testing purposes, name it style.css [code]/* website www.ravestyles.com creator Jarrod W (www.ravestyles.com) updated 26/04/2006 created for use with the member management system */ .bodyline {background:#E5E8EE;border:1px ridge #000000} body {background: #246193; color:#FF9900; font: Arial; font-weight: bold; font-size: 12px; } A:link {COLOR: #FFFFFF; FONT-SIZE: 12px; FONT-FAMILY: Verdana, Helvetica; TEXT-DECORATION: none} A:active {COLOR: #FFFFFF; FONT-SIZE: 12px; FONT-FAMILY: Verdana, Helvetica; TEXT-DECORATION: none} A:visited {COLOR: #FFFFFF; FONT-SIZE: 12px; FONT-FAMILY: Verdana, Helvetica; TEXT-DECORATION: none} A:hover {COLOR: #C0C0C0; FONT-SIZE: 12px; FONT-FAMILY: Verdana, Helvetica; TEXT-DECORATION: none} .ihead { font-family: Verdana, Helvetica, Arial, sans-serif; font-size: 24px; font-weight: bold; color: #FEEFB4; } .itext { font-family: Verdana, Helvetica, Arial, sans-serif; font-size: 10px; font-weight: bold; color: #FF9900; } .iheaders { font-family: Verdana, Helvetica, Arial, sans-serif; font-size: 12px; font-weight: bold; color: #FFFFFF; }[/code] Below is what I have come up with so far for editing/deleting information from the roster but haven't completed yet and not sure if it works, feel free to build on the code if you wish though. Again none of these pages have a redirect on them, sorry about that. This page should be used to collect info for updating or user to be deleted, this should be linked to the $id's pulled from the MySQL database to work with variables, i.e update.php?id=1 here is the code I have so far: [code]<html> <head> <title>Ravestyles NZ Dev - Test Page</title> <meta http-equiv="Content-Type" content="text/html; charset=unicode"> <meta name="keywords" content="test page"> <link rel=StyleSheet href="style.css" type="text/css"> </head> <? /* This script written by raVest. Created on the 26/04/2006 Website: http://ravestyles.com Member management system with backend for the creation, updating and deletion of users from a MySQL database. Please contact raVest if you have any concerns or isses on trance@ravestyles.com */ $id=$_GET['id']; include("private.inc.php"); mysql_connect(localhost,$username,$password); $query=" SELECT * FROM members WHERE id='$id'"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $user=mysql_result($result,$i,"user"); $firstname=mysql_result($result,$i,"firstname"); $lastname=mysql_result($result,$i,"lastname"); $position=mysql_result($result,$i,"position"); $email=mysql_result($result,$i,"email"); $rank=mysql_result($result,$i,"rank"); ++$i; } ?> <font class="itext"> <form action="updated.php" method="post"> <input type="hidden" name="ud_id" value="<? echo $id; ?>"> Username: <input type="text" name="ud_user" value="<? echo $user; ?>"><br> First Name: <input type="text" name="ud_first" value="<? echo $first; ?>"><br> Last Name: <input type="text" name="ud_last" value="<? echo $last; ?>"><br> E-mail Address: <input type="text" name="ud_email" value="<? echo $email; ?>"><br> Rank: <input type="text" name="ud_rank" value="<? echo $rank; ?>"><br> <input type="Submit" value="Update"> </form> <form action="deleted.php" method="post"> <input type="hidden" name="ud_id" value="<? echo $id; ?>"> <input type="Submit" value="Delete"> </form> </font>[/code] This is the script that will actually update the information, updated.php: [code]<html> <head> <title>User Updated</title> <meta http-equiv="Content-Type" content="text/html; charset=unicode"> <meta name="keywords" content="test page"> <link rel=StyleSheet href="style.css" type="text/css"> </head> <? $ud_id=$_POST['ud_id']; $ud_user=$_POST['ud_user']; $ud_first=$_POST['ud_first']; $ud_last=$_POST['ud_last']; $ud_email=$_POST['ud_email']; $ud_rank=$_POST['ud_rank']; include("private.inc.php"); mysql_connect(localhost,$username,$password); $query="UPDATE members SET user='$ud_user', first='$ud_first', last='$ud_last', email='$ud_email', rank='$ud_rank' WHERE id='$ud_id'"; mysql_query($query); echo "Roster Updated"; mysql_close(); ?>[/code] This is the script which will actually delete the user, note the only diff between this and the update.php file is the $query sent to the MySQL. this is to be named deleted.php: [code]<html> <head> <title>Ravestyles NZ Dev - Test Page</title> <meta http-equiv="Content-Type" content="text/html; charset=unicode"> <meta name="keywords" content="test page"> <link rel=StyleSheet href="style.css" type="text/css"> </head> <? $ud_id=$_POST['ud_id']; $ud_user=$_POST['ud_user']; $ud_first=$_POST['ud_first']; $ud_last=$_POST['ud_last']; $ud_email=$_POST['ud_email']; $ud_rank=$_POST['ud_rank']; include("private.inc.php"); mysql_connect(localhost,$username,$password); $query="DELETE members SET user='$ud_user', first='$ud_first', last='$ud_last', email='$ud_email', rank='$ud_rank' WHERE id='$ud_id'"; mysql_query($query); echo "Roster Updated"; mysql_close(); ?>[/code]