Posted by "Gustav Wiberg" on 10/20/38 11:31

----- 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


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/

[Back to original message]