Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-17 Thread Richard Lynch
You can, but it has nothing to do with PHP, and you shouldn't anyway. If you *CARE* about the ID numbers, then you're doing something wrong in the first place. On Sun, April 16, 2006 1:46 am, alex wrote: > hi everyone > > i have delete a few entries in my database as they were entered for > testi

RE: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Jay Blanchard
[snip] i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow r

Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Ryan A
Oops sorry, I made a little mistake here: click on the database name so that you have a list of tables in the *right* frameI meant: click on the database name so that you have a list of tables in the *LEFT* frameCheers,Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Ryan A
Alex, Heres a very simple way to do exactly what you want as long as you are deleting all the records from the table: once you are in phpmyadmin you should have a frame with the database name(s) on the left and the tables on the right, click on the database name so that you have a list of tables i

Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread tedd
At 4:46 PM +1000 4/16/06, alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so

Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Kevin Kinsey
alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it

Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread chris smith
On 4/16/06, Jim Lucas <[EMAIL PROTECTED]> wrote: > chris smith wrote: > > On 4/16/06, Jim Lucas <[EMAIL PROTECTED]> wrote: > > > >> Jim Lucas wrote: > >> > >>> alex wrote: > >>> > hi everyone > > i have delete a few entries in my database as they were entered for > testing purpo

Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Jim Lucas
chris smith wrote: On 4/16/06, Jim Lucas <[EMAIL PROTECTED]> wrote: Jim Lucas wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i

Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread chris smith
On 4/16/06, Jim Lucas <[EMAIL PROTECTED]> wrote: > Jim Lucas wrote: > > alex wrote: > >> hi everyone > >> > >> i have delete a few entries in my database as they were entered for > >> testing purposes and are no longer need (actually 102 entries)... and > >> even thought that db is empty i noticed

Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Jim Lucas
Jim Lucas wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was

Re: [PHP] phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Jim Lucas
alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it p