having issue with mysql command

[AnnetteB1305]

Hello,

I have tested this in Navicat and working fine but it is throwing an error when putting this into a command in crystal reports. It is saying there is an error in the sql syntax. If I take out this section
set @rownum=0;
Select
@rownum := @rownum +1 as ranknum,
then fine but I need a rownumber to show a rank. Any help would be greatly appreciated

Thanks,

Annette

 

[AnnetteB1305]

Apologies realised I've missed the error

Failed to retrieve data from database. details 42000 [MYSQL] [ODBC 3.51 Driver] [mysqld-4.0.16] You have an error in your SQL syntax. Check the manual that corresponds with your MYSQL server version for the right syntax to use near 'Select @rownum :=@rownum +1 as ranknum,cust_name, count(dist [Database Vendor Code:1064 ]

Thanks,

Annette