SQL Top Question ?

[developer]

Hello!

I use this to get the three highest rows regarding to topic_id, but get this 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 '3 * FROM forum_topic ORDER BY topic_id DESC' at line 1

$Query = "SELECT TOP 3 * FROM forum_topic ORDER BY topic_id DESC";

Thankful for help.

[BlueMeteor]

"TOP number" is special SQL syntax in ms sql-server

In mysql

"SELECT * FROM forum_topic ORDER BY topic_id DESC limit 0,3"

[developer]

Works great. Thank you very much BlueMeteor. 🙂