Code: Select all
<html>
<head>
<script type="text/javascript">
function showusername(str)
{
document.forms['change'].username.value = str;
}
</script>
</head>
<body>
<?php
// Connects to your Database
$link = mysql_connect("?", "?", "?") or die(mysql_error());
mysql_select_db("?",$link) or die(mysql_error());
if (!mysql_select_db("?", $link))
{
echo 'Could not select database';
exit;
}
?>
<center><table><tr><td>Member Username:</td><td>
<?php
echo "<select onchange=\"showusername(this.value)\">";
$data = mysql_query("SELECT username FROM members");
while($row = mysql_fetch_assoc($data))
echo '<option value="'.$row['username'].'">'.$row['username'].'</option>';
echo '</select>';
mysql_close();
?>
</td></tr></table></center>
<center>
<table border=1 cellpadding=5 cellspacing=0 width=350>
<center><h2><span style="color: #CC0000">Edit a User</span></h2></center>
<form name="change" action="editmember.php" method="post">
<tr><td>User Name:</td><td>
<input type="text" name="username" maxlength="60" value="" />
</td></tr>
<tr><td>Type:</td><td>
<select name="type">
<option>Singles</option><option>Tag Team</option><option>Stable</option><option>Manager/Valet</option><option>Staff</option><option>Referee</option></select>
</td></tr>
<tr><td>Password:</td><td>
<input type="password" name="pass" maxlength="10">
</td></tr>
<tr><td>Confirm Password:</td><td>
<input type="password" name="pass2" maxlength="10">
</td></tr>
<tr><th colspan=2><input type="submit" name="editmember" value="Edit Member"></th></tr> </table>
</form>
</td>
</tr>
</table>
</center>
</body>
</html>