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@lists.php.net> From: [EMAIL PROTECTED]> Date: Wed, 29
Aug 2007 13:49:02 -0400> Subject: [PHP] 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>
[EMAIL PROTECTED]> >
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
