<form action="alt_new.php" method="post">
    Alt name: <input type="text" name="altname" value=""><br />
    Alt realm:
    <select name="altrealm">               
<?php
        $realmquery = "SELECT realmname FROM realms;"; //where region=userregion
        $realmresults = mysql_query($realmquery) or die(mysql_error());
                
		while ( $row = mysql_fetch_assoc($realmresults))
        {
            foreach ($row as $val1)
            {
                echo "<option value=\"";
                echo $val1; //internal ref
                echo "\">";
                echo $val1; //display text could have realm name + pvp/rp + region
                echo "</option>";
            }
        }
?>
    </select>
    <br />
	<!--in future: grab this from armory -->	
    Faction: &nbsp;
		<input type="radio" name="faction" value="1">Alliance &nbsp;
		<input type="radio" name="faction" value="2">Horde
	<br />
	<br />
    <input type="submit" name="submit" value="Create"> &nbsp; 
    <input type="reset" value="Clear">
</form>