So the code could be
WHERE i.image_active = 1 AND i.cat_id = 98 AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
ORDER BY RAND()
LIMIT 0, 36
";
1. I'm using the Media-Site MOD (with videos), but video-pictures won't be shown...
So, I need to specify in "WHERE", which cat-ids I'd like to show.
But HOW to say... cat 1,2,3,4???I've found a solution (but I think it's not the best):
WHERE (i.cat_id = 3
OR i.cat_id = 23
OR i.cat_id = 19
) AND i.image_active = 1 AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
ORDER BY RAND()
LIMIT 0, 90
";
2. Is it also possible, to show the Category-Name in the description?
I've already tried $cat_name, but the output is absolutly wrong.
3. I set the Limit to "0, 500"... is this bad? This seems a stupid
question, but for me I don't see any probs with this setting.