|
|
Posted by "Gustav Wiberg" on 10/19/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/
Navigation:
[Reply to this message]
|