Hallo Jan,
danke für die prompte Antwort.
Leider geht es nicht. Diese Fehlermeldung kommt dann:
AND cat_id <>27 habe ich hier fett gemacht.
DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM digifototreffimages i, digifototreffcategories c LEFT JOIN digifototreffusers u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 35, 6, 30, 25, 31, 28, 36, 34, 9, 26, 32, 29, 7, 23, 10, 27, 15, 5, 21, 17, 2, 24, 3, 19, 16, 33, 20, 4, 22, 18, 14, 8) AND cat_id <> 27 ORDER BY i.image_date DESC LIMIT 5
Column: 'cat_id' in where clause is ambiguous