Mysql error
#1

Hey im having an error with my sql.

Code:
pawn Код:
format(query, sizeof(query), "SELECT `id_member` FROM `members` WHERE `member_name` = '%s'",playerName);
mysql_query(query, MYSQL_RESULT_REGISTER, playerid, connection);
mysql_store_result(connection);
mysql_fetch_field("id_member",result,connection);
Error:
Quote:

[02:42:01] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed.
[02:42:01] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored.
[02:42:01] [MySQL] Error (0): Could not execute query. Unknown column 'aqweqaaw' in 'where clause'.

whats wrong with the query?
Fix = +rep
Reply


Messages In This Thread
Mysql error + REP - by Cheesus - 17.11.2014, 00:51
Re: Mysql error - by OsteeN - 17.11.2014, 06:17
Re: Mysql error - by CoaPsyFactor - 17.11.2014, 06:51
Re: Mysql error - by Cheesus - 17.11.2014, 09:15
Re: Mysql error - by CoaPsyFactor - 17.11.2014, 09:27
Re: Mysql error - by Cheesus - 17.11.2014, 10:36
Re: Mysql error - by CoaPsyFactor - 17.11.2014, 11:44
Re: Mysql error - by Cheesus - 17.11.2014, 11:52
Re: Mysql error - by CoaPsyFactor - 17.11.2014, 12:25
Re: Mysql error - by Cheesus - 17.11.2014, 12:42

Forum Jump:


Users browsing this thread: 1 Guest(s)