[orange]

hi,

i have a problem with my php inventory system. when I trying to add new data its shows

INSERT INTO `site_users` (`user_id`,`user_name`,`user_login`,`user_password `,`user_level`,`user_email`) VALUES('','fendi','fendi','test',0,'fendi@yahoo.co m')Incorrect integer value: '' for column 'user_id' at row 1

I only can add data thru SQL queries. i try to make id as null but still cannot...

[dgreenhouse]

That's because you're not providing an integer value. If you want to insert NULL, the field definition must allow NULLS.

It appears to me that user_id would be an auto_increment field anyway and should be handled by the database engine. I could be wrong.

[job0107]

Originally Posted by orange

hi,

i have a problem with my php inventory system. when I trying to add new data its shows

INSERT INTO `site_users` (`user_id`,`user_name`,`user_login`,`user_password `,`user_level`,`user_email`) VALUES('','fendi','fendi','test',0,'fendi@yahoo.co m')Incorrect integer value: '' for column 'user_id' at row 1

I only can add data thru SQL queries. i try to make id as null but still cannot...

If the user_id is an auto-increment field then leave it out:

INSERT INTO `site_users` (`user_name`,`user_login`,`user_password `,`user_level`,`user_email`) VALUES('fendi','fendi','test',0,'fendi@yahoo.co m')

But if it is a generic int field then make it 0"

INSERT INTO `site_users` (`user_id`,`user_name`,`user_login`,`user_password `,`user_level`,`user_email`) VALUES(0,'fendi','fendi','test',0,'fendi@yahoo.co m')