Wrong numbers in mysql

Question

I want to enter my XP in mysql. Now is the xp with a , so i removed them with a small script. Now i want to enter them in mysql and this is what i get : Overallxpnow = 8388607

Now the problem is my xp is 328,147,065. So it's is not right. I entered a echo with the variable that is used to get it in mysql and it shows the 328 xp amount (the correct one). The problem is that i really have no idea why it is showing me the wrong number.

This is the script :

$result = mysql_query("SELECT * FROM track WHERE `rsname` ='$name'"); if( mysql_num_rows($result) > 0) { mysql_query("UPDATE track SET `rsname` = '$name', `overallranknow` = '$Overalln', `overalllevelnow` = '$Overall[1]', `overallxp` = '$Overalln2' WHERE `rsname` = '$name', `overallranknow` = '$Overalln', `overalllevelnow` = '$Overall[1]' `overallxpnow` = '$Overall2'"); } else { mysql_query("INSERT INTO track (`rsname`, `overallranknow`, `overalllevelnow`, `overallxpnow` ) VALUES ('$name', '$Overalln', '$Overall[1]', '$Overall2')"); } }

This is the code to remove the ,

$value2= $Overall[2]; $bad_symbols2 = array(",", "."); $Overall2 = str_replace($bad_symbols2, "", $value2);

I hope i told as mutch info as i can.

Also i'm using mediumint as tabel type.

~Kev (bad english = sorry)

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — Madara's Ghost
– Madara's Ghost, Commented Jul 9, 2013 at 11:39
Use a larger data type. MEDIUMINT: minimum value: -8388608, maximum value: 8388607 — user1233508
– user1233508, Commented Jul 9, 2013 at 11:40
@DCoder Thanks got it working now! changed to a bigint Also i did not now that about the mysql_*. Because that's what i always use. — Kev30
– Kev30, Commented Jul 9, 2013 at 11:42
When I have a problem with limiting to a number, I put the number in google, it always shows an article where says it's maximum for something, if it is. — Ivan Yonkov
– Ivan Yonkov, Commented Jul 9, 2013 at 11:43
Assuming that XP can only be positive it might be worth changing it from a signed to an unsigned field as well. — Kickstart
– Kickstart, Commented Jul 9, 2013 at 12:15

Bart Friederichs · Accepted Answer · 2013-07-09 11:41:28Z

2

You are using the wrong field type. The documentation says MEDIUMINT has a range of -8388608 to 8388607.

answered Jul 9, 2013 at 11:41

Bart Friederichs

33.8k16 gold badges112 silver badges219 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CodeAngry Over a year ago

+1 This is what happens when you go cheap on datatypes :) Know thy datatypes and their sizes, only then can you make informed DB design decisions.

Collectives™ on Stack Overflow

Wrong numbers in mysql

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related