mySQL problem

[Chevy]

I have this query...

 

$insert = mysql_query("INSERT INTO `useritems` (`itemid`,`owner`,`amount`) VALUES ('$itemid','$userinfo[username]','1')") or die(mysql_error());

 

All the query works except when the amount goes in it is not 1, it just goes in as a blank spot.

 

Any idea whats wrong?

[hvle]

for the amount, try use 1 instead of '1'.

 

if it doesn't work, please post the datatype for amount

[Chevy]

Nope didn't work...

 

In the mySQL table it is:

 

amount  int(12)  NULL=No  DEFAULT=0

 

Nothing else...

[hvle]

ahhh

VALUES ('$itemid','{$userinfo[username]}','1')"

 

You need to wrap array item with brackets {}

 

better yet:

VALUES ('$itemid','{$userinfo['username']}','1')"

 

single around array key is very important.

[Chevy]

Yea this is really weird but it still isn't working...

 

I don't understand, because the variables both go into the database but the 1 will not.

[hvle]

yes, very weird.

 

Can you post the table structure?  The create table code

[Chevy]

CREATE TABLE `useritems` (
`id` INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`owner` VARCHAR( 255 ) NOT NULL ,
`amount` INT( 12 ) NOT NULL ,
`itemid` INT( 12 ) NOT NULL
) ENGINE = MYISAM ;

[Chevy]

Okay I found the problem...

 

I had a query about 20 lines below that was resetting it for some reason..

 

Sorry about that

 

Thanks for the help though!

[hvle]

LOL, ok