Re: record ID problem

From: Date: Fri, 03 Dec 2004 12:24:59 +0000
Subject: Re: record ID problem
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-203415@lists.php.net to get a copy of this message
Ahmed Abdel-Aliem wrote:
i have a script which reads and edit and delete records from a database table. the proplem is i nthe ID field. when i delete a row the sequence of numbers still the same, i need a function which return the IDs in the form of 1 2 3 4 5 6 7 8 9 instead of 1 3 7 9, can anyone help me plz ?
How about you describe what you're trying to do instead of what you think you need to accomplish it. If you need a continuous count, then use a variable and start a counter as you print out rows. If holes in your record ID column is messing up your application, you're using it for the wrong reasons. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com

« previous php.general (#203415) next »