Author Topic: Include just particular cat  (Read 2115 times)

0 Members and 1 Guest are viewing this topic.

Offline trez

  • Hero Member
  • *****
  • Posts: 613
    • View Profile
    • blog / photography
Include just particular cat
« on: March 11, 2006, 11:20:01 PM »
Hi, thats some lines i use:

Quote
$selection = array('rating');
 $selection_alt = array('rating DESC', 'name ASC', 'name ASC', 'name ASC');
$not_in_cat = "1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,
39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,
78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,
112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,
140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,
168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,
196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,
224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,
252,253,254,255,256,256,257,258,259,260";
# $selection_cutoff = array(' AND i.image_votes > 10', '', '', '', '');

its abaout a mod, but my question is PHP related. In this code, i have excludet 259 categorys, because i want to show only one of them. How can that code be different, so i can specify only the one category i want to use?

something like:

Quote
$selection = array('rating');
 $selection_alt = array('rating DESC', 'name ASC', 'name ASC', 'name ASC');
$in_cat = "cat_numer_xxx, cat_number_xxx";
# $selection_cutoff = array(' AND i.image_votes > 10', '', '', '', '');


georgi

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: Include just particular cat
« Reply #1 on: March 11, 2006, 11:31:38 PM »
You will need to the changes in mysql query (not what you showed).
so would be something like:
WHERE cat_id IN (xx,xx,xx)
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)