fetching field in numeric order.

[Anon]

I made a database in mysql called topscores. I'm making a topscore script to show who has the top score in our team. Now I put some fields in the table topscores.
Through a script I can post records in those fields. Example. Fiels Name1 has Record 3.
So Name1 scored 3 goals. Hope you can still follow me here.
Now I want to know how to read the data from these fields so that the person with most goals shows on top of the website.

Help me please..

Milan.

[brandonschnell]

SELECT name, score FROM TABLE ORDER BY score DESC

[Anon]

SELECT name1, record FROM topscores ORDER BY record DESC

Jon

[Anon]

But how do i print it in order on a page then?

[Anon]

The select statement I noted earlier will order the result into a array (highest record first). All you need to do is loop through the array and print each index value.

$query = "SELECT name1, record FROM topscores ORDER BY record DESC";
$result = mysql_query($query);

while ($row = mysql_fetch_array ($result)) {
PRINT "$row["name1"] - $row["record"]<BR>\n";
}

Jon

[Anon]

@!#$ still doesn't work..
though i appreciate the help guys!
does someone know how to read all fields and sort them by the records?