Can someone check this?

[Usarjjaco]

Hey everyone,I'm using several scripts similar to this to enter items into a players data table. This one is giving me a fit.

mysql_query("INSERT INTO weapon (username, item, pic, weight, type, npcid, vid, bid, quan) VALUES ('$uname', '$tobuilditem', '$itempic', '$itemweight', '$type', '0', '0', '$bid', '1')");

All of the values are inserting except for the one on the end (the '1'), which corresponds to the quan column.It works just fine in another table (The items table) but in this table (The weapon table) it wont put that in for the quantity.Any help would be appreciated. I'm sure it's something small I'm missing.

[xjx424]

is it just showing up blank in the database? What datatype are you using for that column?

[Usarjjaco]

It always shows up as 0 in the database table. I'm using a INT type for the data.

[HungryMind]

Hi!Try Use Value '1' Without Quotations, Or Just Set Variable To 1 Then Use Variable In Your QueryLike: $one = 1;mysql_query("INSERT INTO weapon (username, item, pic, weight, type, npcid, vid, bid, quan) VALUES ('$uname', '$tobuilditem', '$itempic', '$itemweight', '$type', '0', '0', '$bid', '$one')");

[justsomeguy]

That's going to do exactly the same thing. If you're inserting a number, you don't need to put quotes around the value. Quotes mean it's a string.

[HungryMind]

Xctly My Friend :)Congr8

[justsomeguy]

Right, but you still have quotes around it:mysql_query("INSERT INTO weapon (username, item, pic, weight, type, npcid, vid, bid, quan) VALUES ('$uname', '$tobuilditem', '$itempic', '$itemweight', '$type', '0', '0', '$bid', '$one')");

[HungryMind]

So Plz Correct, My Mistake

[thescientist]

so I think ultimately you're going to want to go for something like this:

mysql_query("INSERT INTO weapon (username, item, pic, weight, type, npcid, vid, bid, quan) VALUES ('$uname', '$tobuilditem', '$itempic', '$itemweight', '$type', 0, 0, '$bid', 1)");

now numbers will be seen as numbers, not strings.

[Usarjjaco]

I'll give that a shot and post results. I'm sure it'll work though, thanks guys.