<b><big>Query Error:</big></b><br>
<br>
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 'AND items.CollectionItemID = cat.CollectionItemID
            ORDER BY Manufactu' at line 5<br>
<br>
The query attempting to execute was:<br>
SELECT items.CollectionItemID
            FROM tblCollectionItems items, tblCollectionCategory cat
            WHERE CollectionID = 1
            AND 
            AND items.CollectionItemID = cat.CollectionItemID
            ORDER BY Manufacturer<br>
<br>
Script failed on line 228<br>