how to auto increment in php code?

[SeeMe]

CREATE TABLE `claims` (
`id` BIGINT NOT NULL AUTO_INCREMENT ,
`datecreated` DATE NOT NULL ,
`timecreated` TIME NOT NULL ,
`ref_no` VARCHAR( 50 ) NOT NULL ,
`emp_id` BIGINT NOT NULL ,
`emp_no` VARCHAR( 10 ) NOT NULL ,
`emp_name` VARCHAR( 255 ) NOT NULL ,
`pp_name` VARCHAR( 100 ) NOT NULL ,
`claim_amt` DOUBLE NOT NULL ,
`link_month` VARCHAR( 2 ) NOT NULL ,
`link_year` VARCHAR( 4 ) NOT NULL ,
PRIMARY KEY ( `id` )
);

may i know how make id in auto increment in php code?

[mwasif]

CREATE TABLE `claims` (
`id` BIGINT NOT NULL AUTO_INCREMENT ,
`datecreated` DATE NOT NULL ,
`timecreated` TIME NOT NULL ,
`ref_no` VARCHAR( 50 ) NOT NULL ,
`emp_id` BIGINT NOT NULL ,
`emp_no` VARCHAR( 10 ) NOT NULL ,
`emp_name` VARCHAR( 255 ) NOT NULL ,
`pp_name` VARCHAR( 100 ) NOT NULL ,
`claim_amt` DOUBLE NOT NULL ,
`link_month` VARCHAR( 2 ) NOT NULL ,
`link_year` VARCHAR( 4 ) NOT NULL ,
PRIMARY KEY ( `id` )
);

may i know how make id in auto increment in php code?

You don't need to make auto increment the id in PHP. Only insert the data without mentioning id column in the query .e.g

INSERT INTO claims (datecreated) values ('2008-04-21');

[ronverdonk]

Or, when you use all values in your insert, specify a zero (0) for the auto_increment column.

Ronald

[SeeMe]

i get it aldy. thank you