--- zhade12 <[EMAIL PROTECTED]> wrote: > Hi please i need help on what to alter below so if i delete a message in php > my admin, the messages will still count in order. Right now if i delete > message 1 > it starts numbering from 2 > Thanks for your replies > > > CREATE TABLE `guestbook` ( > `id` int(4) NOT NULL auto_increment, > `name` varchar(65) NOT NULL default '', > `email` varchar(65) NOT NULL default '', > `comment` longtext NOT NULL, > `datetime` varchar(65) NOT NULL default '', > PRIMARY KEY (`id`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
The primary key of a table is a way to uniquely identify a particular row. It can also be used as a foreign key to a related table. For this reason, you should not try to renumber the primary keys. Instead, add another column for the number you wish to display or use your PHP program to count and generate the numbers. James Keeline
