Ave, This is what I need to do. Let's say, my ID's in a table look like this: 1 7 9 11 12 19 26 27 29 30 I need to alter the table so that the ID's are in a sequence like this: 1 2 3 4 5 6 7 8 9 10 It's easy to manually do this if you have a table with 10 records, but you can't do it manually in a table with 5000 records. I know that I can DELETE the ID Column and recreate it and that will Fix this problem, but doing that over and over with all the tables isn't what I'm really looking for. I just feel there should be a way in PHP to execute a logical query to do this. If not of course I can do the delete/recreate using phpmyadmin, but I just want to see if there's a php script way to do it. Thanks. On 11/8/05 9:22 AM, "Gustav Wiberg" <gustav@xxxxxxxxxxxxxx> wrote: > Hi there! > > Do you want an orderby-statement to be done on ID-field? Is that what you > mean? > I would go to phpmyadmin and fix that in the database-structure. (or some > kind of database-utility) > > /G > http://www.varupiraten.se/ > ----- Original Message ----- > From: "Rahul S. Johari" <rjohari@xxxxxxxxxxxx> > To: "PHP" <php-general@xxxxxxxxxxxxx> > Sent: Tuesday, November 08, 2005 2:37 PM > Subject: Fixing ID's in mySQL Table > > > > Ave, > > Is there a way to fix ID sequence in a MySQL table using PHP? > Basically I have some tables with a lot of records, 1000 to 5000. OID¹ is > the Primary Key column in these tables, and at the time the code was > originally written, there weren¹t much verification of data being input > going on. Thus a lot of junk records were being let in, which had to be > deleted at some point or another. Now the ID sequence is all screwed up. > It¹s not in sequence anymore. > > Is there a way to fix this? > > Thanks, > > Rahul S. Johari > Coordinator, Internet & Administration > Informed Marketing Services Inc. > 251 River Street > Troy, NY 12180 > > Tel: (518) 266-0909 x154 > Fax: (518) 266-0909 > > > Email: rahul@xxxxxxxxxxxxxxxxxxxx > http://www.informed-sources.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
