This site is a testing version, but all data is shared with the live forum.


Raised This Month: $ Target: $400
 0% 

MySQL Multiple queries


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Netsys
Senior Member
Join Date: Feb 2010
Old 01-30-2015 , 07:05   MySQL Multiple queries
Reply With Quote #1

The MySQL Module support multiple queries per thread?

i try to do this:
Code:
new szQuery[256], iData[2];
formatex(szQuery, charsmax(szQuery), "INSERT INTO `stats` (`Nick`) VALUES (^"%s^"); SELECT last_insert_id();", g_szPlayerName[iPlayerID]);
		
iData[0] = 2;
iData[1] = iPlayerID;
SQL_ThreadQuery(g_hSQLTuple, "QueryHandler", szQuery, iData, 2);
and SQL_NumResults return 0
Netsys is offline
Netsys
Senior Member
Join Date: Feb 2010
Old 02-03-2015 , 09:51   Re: MySQL Multiple queries
Reply With Quote #2

bump
Netsys is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 02-03-2015 , 19:53   Re: MySQL Multiple queries
Reply With Quote #3

My guess is that you need an individual query call for each. Is that too much work? I don't understand why you want to put them into one.
__________________

Last edited by Bugsy; 02-03-2015 at 19:56.
Bugsy is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 15:14.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode