Im trying to make a 3 teir dropdown
Sort, Order, User
both will be populated by a database so dont worry about the content inside of them they will be the same stuff in both but in a diffrent order by using php (ajax i guess is what it is since its javascript with php lol)
CODE
<html>
<head>
<script src="selectuser.js"></script>
</head>
<body>
<?php
$c=mysql_connect ("localhost", "database", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("database");
echo "<form>
Sort by:<select name=\"sort_by\">
<option value=\"Name\">Name</option>
<option value=\"level\">Level</option>
<option value=\"email\">Email</option>
<option value=\"cash\">Cash</option>
</select>
<select name=\"sort_by\">
<option value=\"DSC\">DSC</option>
<option value=\"ASC\">ASC</option>
<option value=\"RAND\">RAND</option>
</select>
Select a User:
<select name=\"users\" onchange=\"showUser(this.value)\">";
$sql="SELECT * FROM users";
$result=mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "<option value=\"{$row['userid']}\">{$row['username']}</option>";
}
mysql_close($c);
?>
</select>
</form>
<p>
<div id="txtHint"></div>
</p>
</body>
</html>
<head>
<script src="selectuser.js"></script>
</head>
<body>
<?php
$c=mysql_connect ("localhost", "database", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("database");
echo "<form>
Sort by:<select name=\"sort_by\">
<option value=\"Name\">Name</option>
<option value=\"level\">Level</option>
<option value=\"email\">Email</option>
<option value=\"cash\">Cash</option>
</select>
<select name=\"sort_by\">
<option value=\"DSC\">DSC</option>
<option value=\"ASC\">ASC</option>
<option value=\"RAND\">RAND</option>
</select>
Select a User:
<select name=\"users\" onchange=\"showUser(this.value)\">";
$sql="SELECT * FROM users";
$result=mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo "<option value=\"{$row['userid']}\">{$row['username']}</option>";
}
mysql_close($c);
?>
</select>
</form>
<p>
<div id="txtHint"></div>
</p>
</body>
</html>
heres the page as of right now
http://www.clashofages.com/ajax_demo/user_demo.php
