Re: Pragmatically changing a "Record Number"

On Aug 29, 2007, at 2:41 PM, Stephen wrote:

--- Jason Pruim <japruim@raoset.com> wrote:

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?

Some database concepts: The autoincrement feature is to provide a unique "key" for the record. It does not provide an "order". Many tables have more than one "order". Usually a different field or field determines the order(s). It usually has an index. To provide a row number, based on some order, you need a field for this. Whenever a field is deleted, you would need to repopulate the fields in each record after the deleted record in the database.

Which is exactly what I am trying to figure out :) in excel this would be the same as clearing the info in a row and then sorting it to take out the blank lines :)

I saw a nested SQL query that did this once, but my SQL is not good enough to try to illustrate.

I'll keep looking, I'm sure there is away to do it, but playing with the auto incrementing column may not be the best idea...

Stephen --PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com japruim@raoset.com