Okay, so it’s been a long time since I’ve done any php/sql, and when I did, I was a newb.
I have a script that’s supposed to find duplicates in my table. I don’t want to delete them, just want to view them. Lately the script[php]SELECT common, draconic, notes, author
WHERE common in
( SELECT common
HAVING count(*) > 1 )
ORDER BY common[/php]just lags phpMyAdmin, and doesn’t run. If I wait long enough, it errors out and says maybe I was trying to upload something too big. If I try to cancel it, it still takes quite a while for me to be able to do anything with the database.
I have a friend who knows a little bit of PHP, but all he can advise is that instead of using the SQL box in phpMyAdmin, I write out a php page and separate the queries. I’m trying but I don’t know enough of PHP to have this make much sense, to me or others.
Help! Someone, anyone!