Get 20 highest rows?

[developer]

Hello! 🙂

I am trying to get the 20 highest rows (based on clicks) from the table.

This is the best so far.

$Query = "SELECT TOP 20 FROM table1 ORDER BY clicks ASC";

But I get this error:

Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '20 FROM table1 ORDER BY clicks ASC' at line 1 in query: SELECT TOP 20 FROM table1 ORDER BY clicks ASC

Any ideas please?

Thanks in advance.

[LordShryku]

$Query = "SELECT field FROM table1 ORDER BY clicks DESC LIMIT 20";

Dunno if MySQL has Top N support....

[developer]

Thanks a lot for the help. 🙂

This did the trick:

$Query = "SELECT * FROM table1 ORDER BY clicks DESC LIMIT 20";