Cheap Bastard
New Member
PHP:
//Choose a game from the list of entered games
$body.="<SELECT NAME=\"gametitle\" SIZE=20>";
$sql = "SELECT gametitle FROM cm0";
$result = @mysql_query("$sql",$dbconn);
while($row = mysql_fetch_array($result)){
$curgam=$row['gametitle'];
$body.="<OPTION VALUE=\"$curgam\">";
}
$body.="</SELECT>";
Also, is there a way to have MySQL return results alphabetically? (would be much easier to find and select an option). Thanks!