[Basic Php System: View/edit/delete/add Records]

If you are going to use the auto_increment feature, you need to use an INT. It can't be a VARCHAR. I don't know how you've built your application, but if you want to use auto_increment, you'll have to change the database, and potentially how your application works.

 

Thanks your help.

 

My App. is WORK MANAGER With WORK ID is VARCHAR ( because My Work is begin by CUSTOMER). WORD ID is not INT.

How to FIX it? ()

[Basic Php System: View/edit/delete/add Records]

Hello,

 

This is good lesson! THank you!

 

But I have some problem.

 

CREATE TABLE `players` (

`id` int(11) NOT NULL auto_increment, --> ID is INTERGER.

`firstname` varchar(32) NOT NULL,

`lastname` varchar(32) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

 

In my database, ID is VARCHAR, so with ID is character, this applicaiton is not woork.

How I fix it?

 

Thank you!