Please don't do that...autonumber should not be relied for anything other than a unique row identifier. It should NOT matter to the application what that value is as long as it unique. If you need a count of the number of records, do a query (select count(*) from table...) bastien> To: php-general@xxxxxxxxxxxxx> From: japruim@xxxxxxxxxx> Date: Wed, 29 Aug 2007 13:49:02 -0400> Subject: Pragmatically changing a "Record Number"> > Hi Everyone,> > 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?> > > --> > Jason Pruim> Raoset Inc.> Technology Manager> MQC Specialist> 3251 132nd ave> Holland, MI, 49424> www.raoset.com> japruim@xxxxxxxxxx> > _________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
