将检索到的数据输入数据库

Question

I have a php form with three text boxes (webmeasurementsuiteId, webmeasurementsId, Id) and the values in the text boxes are retrieved from other tables of the database. Now my task is to submit the retrieved values in this php form named (mapping) to the database. I have created the table with the following syntax:

CREATE TABLE `mapping` (
  `webmeasurementsuiteId` INT NOT NULL,
  `webmeasurementsId` INT NOT NULL,
  `Id` INT NOT NULL,
  PRIMARY KEY (Id)
);

But I am getting an sql error as follows:

INSERT INTO mapping(webmeasurementsuiteId,webmeasurementsId,Id) values ('','','7')

ERROR: Incorrect integer value: '' for column 'webmeasurementsuiteId' at row 1

Can anyone correct my error? plz view my coding in this link http://pastebin.com/LELEhRCX

Answer 1

try e.g.

INSERT INTO mapping(webmeasurementsuiteId,webmeasurementsId,Id) values ('1','2','7')

and feel the difference

first two columns are declared as int not null, they can not accept not int and null values