getuser

<?php
/*
*getuser.php
*Copyright 2009
*/
require "mysql.php";
$q=$_GET["q"];
$sql="SELECT * FROM users WHERE user='$q'";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
//this is for admins
echo "<table border='1' align='center'>
<tr><th colspan='2' class='fancy'><a href='profile.php?id=". $row['id'] ."'>". $row['user'] ."</a></th></tr>
<tr>
<td class='alt'>Access:</td>
<td class='alt'>";
if ($row['level'] == 0) {
echo "Normal:<input type='radio' name='level' checked='checked' value='0' />
Admin: <input type='radio' name='level' value='2'  />";
}
if ($row['level'] == 2) {
echo "Normal:<input type='radio' name='level' value='0' />
Admin: <input type='radio' name='level' value='2' checked='checked' />";
}
echo "</td></tr>
<tr>
<td class='fancy'>Email:</td>
<td class='fancy'><input type='text' name='email' value='". $row['email'] ."' /></td>
</tr>
<tr>
<td class='alt'>User name:</td>
<td class='alt'><input type='text' name='ruler' maxlength='16' value='". $row['user'] ."' /></td>
</tr>
<tr>
<td class='fancy'>Password:</td>
<td class='fancy'><input type='password' maxlength='32' name='pass' /></td>
</tr>
<tr><th colspan='2' class='fancy'>Administration</th></tr>
<tr>
<td class='alt'>Ip Ban User:</td>
<td class='alt'>Check to ban.<input type='checkbox' name='ban' value='yes' />
<br />Reason: <input type='text' name='banreason' /></td>
</tr>
<tr>
<td class='fancy'>Delete user:</td>
<td class='fancy'>Check to delete.<input type='checkbox' name='delete' value='yes' /></td>
</tr>
<tr>
<th colspan='2' class='fancy'><input type='submit' value='Administrate'></th>
</tr>
</table>";

?>