Value problem containing comma

Question

Value problem containing comma

Asked 8 years, 11 months ago

Viewed 332 times

0

When executing this query:

mysqli_query($dbc, "insert into toons values(NULL, $toonId, '$toonName', $admin, '$dna', $bank, $money, $hp, '$inventory', $lastPlace)")

I get this mistake:

You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server version for the right syntax to use near ' '', ', ', ', ', ', ')' at line 1

What is causing this?

Check that money is formatted with comma (,).

– Daniel Bastos

2015/07/31 at 20:02
Yes it is, as you can see in the code.

– Junior CT

2015/07/31 at 20:06
Related, Formatting of php numbers

– rray

2015/07/31 at 22:45

1 answer

Browser other questions tagged php mysql

You are not signed in. Login or sign up in order to post.

by Daniel Bastos • 43 points · Answer 1 · 2015-07-31T20:14:34+00:00

Database only accepts decimal places with . (point). If you are passing 1,99 in the variable money is likely to give problem not only in the bank. It uses a replace in the variable of , for ..

mysqli_query($dbc, "insert into toons values(NULL, $toonId, '$toonName', $admin, '$dna', $bank, str_replace(",", ".", $money), $hp, '$inventory', $lastPlace)")