Hi Jason,
I am still getting a problem. if I test the following query in navicat :
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"
I get the following error message:
[SQL] 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"
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"' at line 4
..
In addition, please see attached the DW Test.
If I run the page in a browser with the following query:
mysql_select_db($database_menuConn, $menuConn);
$query_rsCatsSubsProd = "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";
I get this message in the browser:
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
So I am now lost at sea!!
Can you see what I am doing wrong?
Your assistance is MUCH appreciated