[Arjan]

I get a SQL error when the search function is used...
Any idea for a fix?


PHP 4.4.4
MySQL 4.1.18

Invalid SQL:
SELECT dl_files.*, dl_cats.name catname FROM dl_files, dl_cats WHERE (CT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.he ight,p.width,c.catname,c.photos,c.posts
FROM pp_photos p
LEFT JOIN pp_categories c ON c.id = p.cat
WHERE c.cattype = 'c' AND p.cat != 500 AND p.storecat = 0
ORDER BY RAND() OR dl_files.author LIKE '%skin manager%' OR dl_files.name LIKE '%skin manager%' OR dl_files.description LIKE '%skin manager%')
AND dl_files.category = dl_cats.id
ORDER BY catname, dl_files.name;

MySQL 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 'p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.h eight,p.width,c.catname,c.photo' at line 1
Error Number : 1064