I have a Select statement with a subquery and finally a groupby which works perfectly in phpMyAdmin and on my localhost but it doesnt work while i run the script on x10Hosting.
My Query:
SELECT replyid, forcommentid FROM commentreply WHERE forcommentid IN(SELECT commentid FROM comments c...
So, i have a created a php script that will go through all my records in a table and make necessary changes to the records. the problem is the script can take a while to complete and so it exceeds the max time a script can run. Is there a way i could manipulate the database of x10hosting from my...