view_account.inc

不错的东西

<form method="post" action="<?=$_SERVER['PHP_SELF']?>">
<fieldset>
<legend>View Account</legend>
<table>
<tr>
	<td><label for="account_id">Account Username:</label></td>
	<td>
	<select name="account_id" id="account_id">
	<?php
	/*
	*  Justin Osterholt
	*  11/26/05
	*  moved html into php
	*/
	$query = $sql->query("SELECT * FROM accounts WHERE level = '0' AND status = '2'");
	while($data = mysql_fetch_assoc($query)) {
		echo "<option value=\"{$data['id']}\">{$data['username']}</option>\n";
	}
	?>
	</select>
	</td>
</tr>
<tr>
	<td colspan="2"><input type="submit" name="View Account" /></td>
</tr>
</table>