1
Programming / Re: How to modify this sql code
« on: February 24, 2009, 10:55:55 PM »
Thaaaaaaanks aloooooot V@nо
It works fine
It works fine
You're looking for some 4images templates and styles? Then visit this thread to show websites with 4images templates to download.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
AND i.cat_id IN (31,30,28,25,23,22,20,19,35,15,16,18,24,26,32,34,27,33)
$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_thumb_file, i.image_rating, i.image_votes, c.cat_name, u.user_name
FROM ".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c, ".USERS_TABLE." u
WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id AND i.user_id = u.user_id $cat_match_sql AND i.cat_id IN (31,30,28,25,23,22,20,19,35,15,16,18,24,26,32,34,27,33)
ORDER BY i.image_rating DESC, i.image_votes DESC
LIMIT 20";