Hi,

> I originally had a link #1, #2, and #3.  I obviously deleted them.
> I was wondering if there is a way to use PHP/MySQL to get the 
> indexed numbers to re-assign so that the first link you see is 
> always #1 the second link you see is always #2 and so on?

(apologies for previous incomplete message - pressed Ctrl+Enter by mistake
:-)

If these are the primary keys in your database, you can reset the
auto_increment with this query:

  ALTER TABLE tablename AUTO_INCREMENT = 1;

Or set it to whatever you like:

  ALTER TABLE tablename AUTO_INCREMENT = 23;


Cheers
Jon

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

Reply via email to