SQL ERROR.. Why ?

[none]

Hi everybody !

I've some error with mysql request :

.@nb = query_sql("select id,cmd,char from `CMDIST` ORDER BY `id` DESC LIMIT 1", .@id, .@cmd$, .@char$);

(09/02/2014 17:55:11) [ SQL Error ] : DB 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 'from `CMDIST` ORDER BY `id` DESC LIMIT 1' at line 1

(09/02/2014 17:55:11) [ Debug ] : at script.c:16265 - select id,cmd,char from `CMDIST` ORDER BY `id` DESC LIMIT 1

 

Another error with this sql:

query_sql("SELECT COUNT * FROM `auction`",.@count );

Can you explain me where is the error ?

Thx a lot !

 

[anacondaq]

.@nb = query_sql("SELECT  `id`,`cmd`,`char` FROM `CMDIST` ORDER BY `id` DESC LIMIT 1", .@id, .@cmd$, .@char$);

query_sql("SELECT COUNT(column name) * FROM `auction`",.@count );

char - reserved name of MYSQL

Edited September 2, 2014 by Anacondaqq