Please help.. I have no idea whats wrong.
<?
include("accesscontrol.php");
include('../config.php');
include('header.php');
if($createpermission !="true") { echo "You do not have permission to create users.</div></div></body></html>"; }else{
if(!isset($ends_design_add_go)) {
?>
<div align="right">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="85%">
<tr>
<td width="100%">
<form method="post" action="adduser.php" name="addForm">
<input type="hidden" name="id" size="45" value="id" />
<input type="text" name="userid" size="45" value="" />
Username<br />
<br />
<input type="password" name="password" size="45" value="" />
Password<br />
<br />
<input type="text" name="fullname" size="45" value="" />
Full Name<br />
<br />
<input type="text" name="emailaddress" size="45" value="" />
Email Address<br>
<br>
<input type="text" name="URL" size="45" value="" /> Website<br>
<br>
<input type="text" name="pic" size="45" value="" /> Picture<br>
<br>
<input type="text" name="dlevel" size="45" value="" /> Display level<br>
<br>
<? $divisiondrop = "SELECT Gname FROM $divisionprefix ORDER BY id desc";
?>
<select name=division>
<?
$resultdivision=mysql_query($divisiondrop) or die(mysql_error());
while($row=mysql_fetch_array($resultdivision)) {
?>
<option value="<?=$row['Gname']?>"><?=$row['Gname']?></option>
<?
}
?>
</select> Division<br>
<br>
<? $rankdrop = "SELECT rank FROM $rankprefix ORDER BY rnum desc";
?>
<select name=rank>
<?
$resultrank=mysql_query($rankdrop) or die(mysql_error());
while($row=mysql_fetch_array($resultrank)) {
?>
<option value="<?=$row['rnum']?>"><?=$row['rank']?></option>
<?
}
?>
</select> Rank<br>
<br>
<? $titledrop = "SELECT Tname FROM $titleprefix ORDER BY id desc";
?>
<select name=titles>
<?
$resulttitle=mysql_query($titledrop) or die(mysql_error());
while($row=mysql_fetch_array($resulttitle)) {
?>
<option value="<?=$row['Tname']?>"><?=$row['Tname']?></option>
<?
}
?>
</select> Title<br>
<br>
<? $honordrop = "SELECT honor FROM $honorprefix ORDER BY id desc";
?>
<select name=division>
<?
$resulthonor=mysql_query($honordrop) or die(mysql_error());
while($row=mysql_fetch_array($resulthonor)) {
?>
<option value="<?=$row['honor']?>"><?=$row['honor']?></option>
<?
}
?>
</select> Honor<br />
<br>
<textarea rows="7" name="bio" cols="38"></textarea><br>
<br />
<input name="activate" type="checkbox" value="1" />
Activate<br />
<br />
<input name="add2" type="checkbox" value="true" />
Post Entry Permission<br />
<br />
<input name="edit2" type="checkbox" value="true" />
Edit Entry Permission<br />
<br />
<input name="delete2" type="checkbox" value="true" />
Delete Entry Permission<br />
<br />
<input name="create2" type="checkbox" value="true" />
Create User Permission<br />
<br />
<input name="ulevel" type="checkbox" value="true" />
Administrator Permission<br />
<br />
<input name="vamp" type="checkbox" value="true" />
Vamp Member<br />
<br />
<input type="hidden" name="ends_design_add_go" value="TRUE" />
<input name="submit" type="submit" value="Create User" />
</form></div>
</div>
</td>
</tr>
</table>
</div>
<br><br>
</body>
</html>
<?
} else {
$MYSQLCONN = mysql_connect("$host","$username","$userpass") or die("Error connecting to database.");
mysql_select_db("$userdatabase",$MYSQLCONN) or die("The database could not be found.");
$query = "INSERT INTO $userprefix ('id','userid','password','fullname','emailaddress','add2','edit2','delete2','create2','activated','last_login','rank','pic','title','honor','division','bio','ip','ulevel','URL','vamp','dlevel') VALUES ('','$userid','$password','$fullname','$emailaddress','$add2','$edit2','$delete2','$create2','$activated','','$rank','$pic','$title','$honor','$division','$bio','','$ulevel','$URL','$vamp','$dlevel')";
if(!mysql_query($query)) { echo "Error: must be a unique admin user name and id"; } else { echo "User Created </div></div></body></html>"; }
} }
?>
