What am I doing wrong? When I enter the following query:
<?php
$result= mysql_query ("
SELECT Products.prodID, Products.current, Products.caption, Products.image_location, Products.thumbnail, Products.description, Type.type, Theme.theme, Size.size
FROM Products WHERE Type.type='Single Booths'
INNER JOIN Type ON Products.typeID=Type.typeID
INNER JOIN Theme ON Products.themeID=Theme.themeID
INNER JOIN Size ON Products.sizeID=Size.sizeID
") or die (mysql_error());
?>
I get an error:
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 'INNER JOIN Type ON Products.typeID=Type.typeID INNER JOIN Theme ON Products.them' at line 3
Thanks in advance for your help.
