MySQL Syntax Error
#4

PHP код:
mysql_format(mysqlquerysizeof(query), "UPDATE `accs` SET `pName` = '%s', `pSecKey` = %d, `pLevel` = %d, `pRespect` = %d, `pSkin` = %d, `pIP` = '%s', `pAdmin` = %d, `pVIP` = %d, `pMoney` = %d, `pGender` = %d, `pAge` = %d, `pBank` = %d, `pBanned` = %d, `pBans` = %d, `pBannedBy` = '%s', `pBanReason` = '%s',  `pBanDate` = '%s', `pBanTime` = '%s', `pBanAppealable` = %d, `pFaction` = %d, `pRank` = %d, `pFacSkin` = %d, `pTester` = %d, `pTutStep` = %d, `pFinishedTut` = %d, `pMuted` = %d, `pPosX` = %f, `pPosY` = %f, `pPosZ` = %f, `pPosA` = %f WHERE `pID` = %d" 
try that



_
as for the post above me..
If you read the error, You clearly see the issue.

The "IP" is being define as %e
an he's attempting to pass it through to a "VARCHAR" column, Hence why it opens the column into '255.255,
Reply


Messages In This Thread
MySQL Syntax Error - by JaydenJason - 04.07.2015, 12:14
Re: MySQL Syntax Error - by rymax99 - 04.07.2015, 12:25
Re: MySQL Syntax Error - by prineside - 04.07.2015, 12:26
Re: MySQL Syntax Error - by Prokill911 - 04.07.2015, 12:30
Re: MySQL Syntax Error - by JaydenJason - 04.07.2015, 12:32
Re: MySQL Syntax Error - by Prokill911 - 04.07.2015, 12:34
Re: MySQL Syntax Error - by rymax99 - 04.07.2015, 12:34
Re: MySQL Syntax Error - by Prokill911 - 04.07.2015, 12:37
Re: MySQL Syntax Error - by rymax99 - 04.07.2015, 12:38
Re: MySQL Syntax Error - by JaydenJason - 04.07.2015, 12:45

Forum Jump:


Users browsing this thread: 2 Guest(s)