limit messes up code

[googlexx]

when i add LIMIT to my query i get this error:

 

Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][ODBC Microsoft Access Driver] Syntax error in ORDER BY clause.' in C:\xampp\htdocs\top10.php:16 Stack trace: #0 C:\xampp\htdocs\top10.php(16): com->Execute('SELECT Username...') #1 {main} thrown in C:\xampp\htdocs\top10.php on line 16

 

This is my query

 

$rs = $conn->Execute("SELECT Username, Experience, Wins, Losses, State, MVP FROM users ORDER BY Experience desc LIMIT 10");

 

[otuatail]

This is a microsoft Access problem. You need to get help there. I don't think you can use LIMIT.

 

Desmond.