SQL Help
#9

Quote:
Originally Posted by Luke_James
Посмотреть сообщение
PHP код:
format(querysizeof(query), "UPDATE `licenses` SET `licID` = '%d', `ownerID` = '%d', `issuerID` = '%d', `issueDate` = '%s' WHERE `ID` = '%d'",
        
LicenseData[playerid][licID],
        
LicenseData[playerid][ownerID],
        
LicenseData[targetid][issuerID],
        
LicenseData[playerid][issueDate]
    ); 
All of that?
Whatever you format here will be inserted into `query`. If your intended query is longer than 767 characters, it won't send the full query. Though, your array length should be fine for such short query.
Reply


Messages In This Thread
SQL Help - by Luke_James - 17.08.2015, 16:14
Re: SQL Help - by DaniceMcHarley - 17.08.2015, 16:20
Re: SQL Help - by arad55 - 17.08.2015, 16:26
Re: SQL Help - by Luke_James - 17.08.2015, 16:27
Re: SQL Help - by Luke_James - 17.08.2015, 16:31
Re: SQL Help - by DarkLored - 17.08.2015, 16:31
Re: SQL Help - by Luke_James - 17.08.2015, 16:36
Re: SQL Help - by DaniceMcHarley - 17.08.2015, 16:38
Re: SQL Help - by arad55 - 17.08.2015, 16:42
Re: SQL Help - by Luke_James - 17.08.2015, 16:43

Forum Jump:


Users browsing this thread: 1 Guest(s)