[ajwar]

HI, how to make a big mysql query?

now i have 3 768size queries which i think leads to db overloading.

If i try to make bigger one i get error: input line to long.

Any suggestions?

[KingTurtle]

Set

pawn Код:

new query[(size of yours)];

to

pawn Код:

new query[800];

If that doesn't work, then you should try

pawn Код:

format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
format(query, sizeof query, [string here], [data here]);
mysql_query(%s);

Just alot of queries and then save it as one

(Sorry, I don't know how mysql_query syntax is)