Also, should have mentioned this before, but the query I provided just sets the integer value of the AUTO_INCREMENT field, it doesn't give the field itself AUTO_INCREMENT capability.
Here's an example of the CREATE TABLE query, which will set the AUTO_INCREMENT value with the creation of the table.
CREATE TABLE `submissions` (
`submission_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`date` text NOT NULL,
`category_id` int(11) NOT NULL default '0',
`title` text NOT NULL,
`body` mediumtext NOT NULL,
`permission` int(1) NOT NULL default '0',
`lastaccesstime` timestamp(14) NOT NULL,
PRIMARY KEY (`submission_id`)
) TYPE=MyISAM AUTO_INCREMENT=999999999 ;
: )
Rich
:::::::::::::::::::::::::::::::::
Smiling Souls
http://www.smilingsouls.net
:::::::::::::::::::::::::::::::::