[Pawn] Saving variables into multiple tables

[Pinch]

You can enable mysql option, MULTI_STATEMENTS, (mysql_set_option, toggling the mentioned option (true)) and have multiple MySql queries executed in a single mysql query native.

For example

Code:

INSERT INTO `something`...; INSERT INTO `something else`...;

Notice the semicolon

Sorry for the bad example, I don't have a PC at the moment so I can't really write much of an example but I found this (example is using primary keys - you should consider using foreign keys instead):
https://stackoverflow.com/questions/1047...involved-t