Hi All,
Somehow, this query is throwing a parse error, and I cannot figure out why. It works on my local machine, bu live it throws this:
SQL-query :
SELECT DISTINCT I_id, I_name, I_extentie, I_id, I_country, I_thwidth, I_thheight, I_title
FROM f_images
INNER JOIN (
f_theme
INNER JOIN f_imgtotheme ON ( (
T_id = It_themenr
) AND (
(
T_themes = 'Animals'
) )
)
) ON ( I_id = It_imgnr )
WHERE 1 =1
GROUP BY I_id
HAVING COUNT( I_id ) =1
ORDER BY I_id DESC
LIMIT 0 , 30
MySQL said:
#1064 - You have an error in your SQL syntax near '( f_theme
INNER JOIN f_imgtotheme ON ( ( T_id = It_themenr ) AND ( ( T_themes =' at line 3
Please tell me what I am doing wrong..
J.
