You have an error in your SQL syntax

Er lige skiftet fra Access til MySQL - har MySQL 5.0, OBCD 2.50 driver og MySQL Front... når jeg så prøver at tælle i hits fra databasen siger den

[TCX][MyODBC]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 '10 * from Guides order by ID desc' at line 1

/kristian/MySQL/monkey/Default.asp, linje 385

Mit kode stykke ser således ud:

<%

Set conn = Server.CreateObject("ADODB.Connection")
strConnect = "DRIVER={MySql}; SERVER=webonnet; DATABASE=database; UID=root; PWD="
Conn.Open strConnect

Set hits = Conn.Execute("SELECT COUNT(id) AS antal FROM hits")

Set tuts = Conn.Execute("SELECT COUNT(id) AS tuts FROM guides")

Set rs = Conn.Execute("Select top 10 * from Guides order by ID desc")

  Response.Write "<font style='font:bold 9 verdana'><hr>Stats</font><hr>"

  Response.Write "<font style='font:9 verdana'>Hits: <i>" & hits("antal") / 2 & "</i><br><br>"

  Response.Write "Tutorials: <i>" & tuts("tuts") & "</i></font>"

  Response.Write "<font style='font:bold 9 verdana'><hr>Nyeste Tutorials</font><hr>"

  Response.Write "<font style='font:9 verdana'>"

do

  Response.Write "<a href='default.asp?page=guides&id=" & rs("id") & "'>" & rs("navn") & "</a><br><br>"

  rs.MoveNext
Loop While Not rs.EOF

Conn.Close
Set Conn = Nothing

%>

Hvad er fejlen?