[iZN]

Quote:

Originally Posted by BroZeus i am not good at mysql but just opened a gamemode of mysql and in that there is ' ' around every specifier in query why is that and it works pretty good to with it

They're not necessary, but you've to add those apostrophe outside the strings no matter what.

Quote:

Originally Posted by Misiur @OP: I'm not sure if mysql_format supports this, but use %.2f for floats. Why? Normally they take up ~8 chars (0.000000 instead 0.00). And you shouldn't need more precision than 3. Also I still encourage using %e instead of %s. Oh, and simply print your query after mysql_format, then check it out in server log.

He found the issue already.

Quote:

Originally Posted by Jacksta21 EDIT: That was the issue, thanks for that! My idiocity probably wouldn't have found that alone...