MySQL ORDER BY problem

[Anon]

I have this following problem with MySQL & PHP.

Error
SQL-query:

SELECT lname, fname FROM players ORDER BY lname, fname ASC LIMIT 0,10
MySQL said:

This was printed out from phpMyAdmin when I tried to do the query. I was wanted to print out a table with names sorted by last name, and then by first name.

Somehow it's not working. Can you help me?

[bretticus]

well, I can't see what your error was, it's been stripped out, but your query looks fine to me. ASC is the default so it's optional, but unless I know what the error is, I can't help you.