1
Programming / How to modify this sql code
« on: February 24, 2009, 10:09:46 PM »
Hi every body,
can some one help me to modfy this sql to make it get data from the man category and it's sub categories without including the id of Each sub category
this is my way
I want the code to get the sub categories automaticly
can some one help me to modfy this sql to make it get data from the man category and it's sub categories without including the id of Each sub category
this is my way
Code: [Select]
AND i.cat_id IN (31,30,28,25,23,22,20,19,35,15,16,18,24,26,32,34,27,33)
I want the code to get the sub categories automaticly
Code: [Select]
$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";