Re: [PHP] Pragmatically changing a "Record Number"
- From: japruim@xxxxxxxxxx (Jason Pruim)
- Date: Thu, 30 Aug 2007 05:57:25 -0400
On Aug 30, 2007, at 5:14 AM, Stut wrote:
Jason Pruim wrote:Hi Everyone,
Hi Dr Jason.
I think after I get this question answered, I can stop asking for awhile since my project will be done, at least until the users say "What happened to XYZ????" then I'll ask again :)
I asked on a MySQL list about "Resetting a auto increment filed" so that there arn't any gaps in the record number.
So to say it another way, I have a table that has 900 records in it, I've added 3 records, but then deleted 2 of those which puts the actual record count at 901 but my auto increment field starts at 904 on the next insert.
Is there away with PHP that I can pragmatically change that value to the total records in the database more so then a representation of the actual record number?
What are you actually trying to achieve? Why do you need all records to have a sequential number? Ignore how you're going to do it, just tell us why you think you need this, because I've never come across a reason to need this.
What I am trying to achieve, is something along the lines of excel... You can clear out a row in excel, and then "sort" all the blank lines out renumbering the records. Basically, the people I'm going to sell this app too, are used to using excel, so I'm attempting to mimic as much of it as I can.
Does that help clear it up?
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
japruim@xxxxxxxxxx
.
- Follow-Ups:
- References:
- Pragmatically changing a "Record Number"
- From: Jason Pruim
- Re: [PHP] Pragmatically changing a "Record Number"
- From: Stut
- Pragmatically changing a "Record Number"
- Prev by Date: Problem mysql_connect : True PB ?
- Next by Date: mod_rewrite problem
- Previous by thread: Re: [PHP] Pragmatically changing a "Record Number"
- Next by thread: Re: [PHP] Pragmatically changing a "Record Number"
- Index(es):
Relevant Pages
|
