mysql (strickenKid) wont load data
#7

mhh im kinda new to mysql so i need ur help guys

i got this error messages printed in the server logs:

Код:
[00:12:03] [MySQL] Error (0): Failed to exeute query. 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 `Users` WHERE `name` = 'TestPlayer'' at line 1.
[00:12:03] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. 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 `Users` WHERE `name` = 'TestPlayer'' at line 1.
[00:12:03] [MySQL] Error (0): Function: mysql_store_result called when no result stored. 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 `Users` WHERE `name` = 'TestPlayer'' at line 1.
[00:12:17] [MySQL] Error (0): Failed to exeute query. 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 `Users` WHERE `name` = 'TestPlayer'' at line 1.
[00:12:17] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. 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 `Users` WHERE `name` = 'TestPlayer'' at line 1.
[00:12:17] [MySQL] Error (0): Function: mysql_store_result called when no result stored. 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 `Users` WHERE `name` = 'TestPlayer'' at line 1.
this is the pawno part:

pawn Код:
new Query[1400], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(Query, sizeof(Query), "SELECT FROM `Users` WHERE `name` = '%s'", pname);
    mysql_query(Query);
    mysql_store_result();
    mysql_fetch_row(Query, "|");
    sscanf(Query, "ddd",MoneyVar[playerid],kills[playerid],deaths[playerid]);
    mysql_free_result();
so can u tell me why i keep getting this errors?
Would be very happy to be able to give u guys some Reps+

and also when i spawn i get no money or kills loaded from the file it thinks im a new player without any score.
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)