Problem with sql
#3

Enclose the Lock field with back ticks.

pawn Код:
format(str,sizeof(str),"UPDATE PlayerDealership SET `Lock` = 1 WHERE Owner = '%s'",Nam);
    mysql_query(str);
Pretty sure lock is a MySQL function and therefore it may screw up your query if you don't use backticks.
Reply


Messages In This Thread
Problem with sql - by Tanush123 - 17.07.2013, 21:16
Re: Problem with sql - by gtakillerIV - 17.07.2013, 21:36
Re: Problem with sql - by [HiC]TheKiller - 18.07.2013, 00:20

Forum Jump:


Users browsing this thread: