[Rokzlive]

Whats wrong with this? I suck at mysql strings.

pawn Код:

new ban[50];
                        format(ban,sizeof(ban),"UPDATE `accounts` SET `Warns`= 3 WHERE name = '%s'",pName2);
                        mysql_query(ban);

[Donya]

pawn Код:

new Query[80];
format(Query,sizeof(Query),"UPDATE `accounts` SET `Warns` = 3 WHERE `name` = '%s'",pName2);
mysql_query(Query);

Query length problem, no biggy.

[XFlawless]

By bad misunderstood. Try new ban[128];

[Rokzlive]

How do i miss so simple a problem?

[XFlawless]

Quote:

Originally Posted by Rokzlive How do i miss so simple a problem?

Next time check your mysql log

[Calgon]

Quote:

Originally Posted by XFlawless By bad misunderstood. Try new ban[128];

...and you need to wrap ` around EVERY field name you use if you use ` once in a query.

[XFlawless]

Thanks for the correction.