Posted by Georgi Ivanov on 10/20/42 11:31

You van do this :
1.Create new table with exactly the same structure as orig table.
2.Create little php script which does this :
select * from origTBL
while($line=mysql_fecth_array($res)){
insert into newtbl values(............)
}

In the new tbl yuo will have the records ordered.
Than just rename the tables.

On Tuesday 08 November 2005 16:28, Rahul S. Johari wrote:
> 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@varupiraten.se> 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@nycap.rr.com>
> > To: "PHP" <php-general@lists.php.net>
> > Sent: Tuesday, November 08, 2005 2:37 PM
> > Subject: [PHP] 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@informed-sources.com
> > http://www.informed-sources.com

[Back to original message]