I have a site that is using a MySQL database and PHP to display it in flash. I have a listbox which i want to sort by order of peoples names from the database, how do i do this???
My database is called FOOTBALL, my table is called PLAYERS and the fields in the table are ID, NAME, DOB, POS, NUMBER, IMAGE, APPS, GOALS, ASSISTS, YELLOW, and RED.
here is the PHP code:
<?
include("config.inc.php");
$connessione = @mysql_connect($server,$user,$pass);
$database = mysql_select_db($database,$connessione);
$select = "SELECT * FROM players";
$result = mysql_query($select);
$rows = mysql_num_rows($result);
while($list = mysql_fetch_array($result)){
$id = $list["id"];
$name = $list["name"];
$dob = $list["dob"];
$pos = $list["pos"];
$number = $list["number"];
$image = $list["image"];
$apps = $list["apps"];
$goals = $list["goals"];
$assists = $list["assists"];
$yellow = $list["yellow"];
$red = $list["red"];
print("Total=$rows& Oggetto$id=$name|$dob|$pos|$number|$image|$apps|$goals|$assists|$yellow|$red&");
}
?>
I think i have to use something like SELECT name FROM players ORDER BY name; but i don’t know where to put this code.
Any help would be greatful.
