Thanks so much for your patience Jason. It is now working!!! The only thing I now need to resolve are that duplicates are showing up.
I have tried SELECT DISTINCT but that doesn't seem to work on:
"SELECT * FROM pages INNER JOIN productsubcategory ON productsubcategory.url = pages.Pageurl WHERE Category LIKE '%Adhesion%' AND SubCategory LIKE '%Pull Off Adhesion Tester%' ORDER BY productsubcategory.myorder ASC";
productsubcategory.url is where the duplicates are located. Is there any way limit the duplicates to just one record shown?