I have a database which contains a table that stores projects such as Movies, Television Shows, Theatre, Music Videos etc. In a series of other tables, there is information stored that relates to each of these projects, such as who the producers are, who the director is, the date that the project starts, the location etc. This information is linked via a foreign key field.
Our database contains many duplicates of the same projects. For example, the same TV show might be in the database 3 separate times - but some records might contain more information than others.
I would like to create a module in PHP that will allow the user to find duplicate projects and merge them. The merge would essentially gather all of the information associated with the projects, delete any replications, update only ONE of the projects and delete the rest. There are approximately 5 other tables that contain data which is linked to the projects table.
There should be a landing page that allows the user to "confirm" before the merge & delete occurs.
12 freelancers are bidding on average $168 for this job
I saw the sample record attached in the image. Can you please confirm the expected output? Relevant Skills and Experience PHO Dev Proposed Milestones $210 USD - End
I can do as per screenshot and description of project for records merging, lets chat Relevant Skills and Experience php mysql Proposed Milestones $150 USD - Initial Milestone
[url removed, login to view] A Nice Day! I read your project details.I can build PHP MySQL script for find duplicates and merge info into one and reset delete .Please Send me a [url removed, login to view] can discuss more Thank you Relevant Skills and Ex Mais
I am having 8 years of experience and I can do your job. Please let me know when to start... Relevant Skills and Experience PHP, MYSQL Proposed Milestones $155 USD - Final