Two queries in one
#2

Try using
pawn Код:
UNION
In between the two queries. So it would be
pawn Код:
UPDATE `players` SET `Name` = '%e' WHERE `PlayerID` = %i UNION DELETE FROM `players` WHERE `PlayerID` = '%i'
Source: http://stackoverflow.com/questions/7...eries-into-one

@Konstantinos - Ooh yeah, My bad
Quote:

The column names from the first SELECT statement are used as the column names for the results returned.

Reply


Messages In This Thread
Two queries in one - by MP2 - 23.05.2015, 17:42
Re: Two queries in one - by Stev - 23.05.2015, 17:48
Re: Two queries in one - by Konstantinos - 23.05.2015, 17:49
Re: Two queries in one - by MP2 - 23.05.2015, 17:51
Re: Two queries in one - by Sithis - 23.05.2015, 17:58
Re: Two queries in one - by MP2 - 23.05.2015, 17:59
Re: Two queries in one - by Konstantinos - 23.05.2015, 18:53
Re: Two queries in one - by Sithis - 24.05.2015, 10:24
Re: Two queries in one - by Yashas - 24.05.2015, 10:33
Re: Two queries in one - by Konstantinos - 24.05.2015, 10:42

Forum Jump:


Users browsing this thread: 1 Guest(s)