Ok could some kind soul point me to the doc's for reseting the index after deleting a few records below is my database and I did a delete where rec >0 and it worked however the index is still at 6 how can I correct this or reset the index to the number of records in the data base hummmmm... Thanks for the help going to try the doc's again :) # Server version 3.23.39-log # # Table structure for table 'guestbook' # CREATE TABLE guestbook ( name varchar(100) default NULL, age varchar(4) default NULL, email varchar(150) default NULL, website varchar(254) default NULL, comments text, time varchar(100) default NULL, rec int(11) NOT NULL auto_increment, PRIMARY KEY (rec) ) TYPE=MyISAM; # # Dumping data for table 'guestbook' # --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php