Hi Guys and Gals,
I currently have a script (two php files) which locate and remove Duplicate content from my Article Sites Database and Re-Optimizes the table. One file is for removing articles with duplicate titles and the other is for removing articles with duplicate body text..
When run from a browser window it corrupts my database tables for some reason. (Might be due to the database size as it is HUGE).
What I would like someone to do for me is to view the code within the PHP file and provide me with a Query I could use from within phpMyAdmin which would essentially do the same thing that the script does.
1/ Locate the duplicates
2/ Delete the duplicates
I am using the Article Dashboard script on my Article Site.
I have attached the 2 files for you to view to see if you can create a query for me to run via phpMyAdmin. (These files used to work when the database was smaller in size.)
Essentially should be a quick job for experienced programmers.