|
|
Posted by Shark on 05/12/07 04:28
I have a database of 1500+ records of contacts in a poorly formed database.
I am looking for a PHP/MYSQL contact management system that I can use to
rebuild my records and go forward. Does anyone have any suggestions?
If not, perhaps I can get some advice on how to write code to handle the
table structures described below:
here is the original table structure:
TABLE NAME: ENTRY
(entry_id (PK), name, category_id, street, city, zip........)
This meant that one entry could only be linked to a one category and have
one address both of which are not true. As a result I have several
duplicate
entries becuase people enter the same entry twice so that they can list
additional addresses and be seen in different categories.
so now I have created 3 tables to handle this:
TABLE NAME: ENTRY
(entry_id (PK), name..........)
TABLE NAME: ADDRESS
(address_id (PK), entry_id (FK), street, city, zip......)
TABLE NAME: CATEGORY
(catindex(PK), entry_id (FK), category_id(FK) )
I am having trouble writing code to migrate the the data from the old table
structure to the new one.
Navigation:
[Reply to this message]
|