auto_increment create table?

[Anon]

Hello,

I have created a table. I want this table's ID to be auto incremented when user inserts new data, and I build sql for table creation as following..but it is not working..

$sql= 'CREATE TABLE sometable (id int(11) default auto_increment, field1 int(25), field2 varchar(25), field3 int(25));';

any help appreciated.

thanks.

[Anon]

I'm not an expert but I don't think an INT can have more than 11 in Length/Set, maybe that's the problem.

Peter

[Anon]

Thanks a lot Peter.

I have corrected those ints..

But the main solution came out when I changed sql to the folowing..

$sql= 'CREATE TABLE sometable (id int(11) default NULL auto_increment, field2 int(10) default NULL, fiel1d varchar(25) default NULL, field3 int(10) default NULL, PRIMARY KEY (id)) TYPE=MyISAM;';

Hope this helps somebody, someday ...

[Anon]

I created my auto incrementing table like this:<br><br>create table main( inum int primary key auto increment);

[Anon]

what about:

$sql= 'CREATE TABLE sometable (id int(11) NOT NULL default 0 auto_increment, field2 int(11) NOT NULL default 0, fiel1d varchar(25) NOT NULL default \'\', field3 int(11) NOT NULL default 0, PRIMARY KEY (id));';

for alot of reasons, if you avoid null as much as possible, its for the best. But that is only a suggestion.