<CONFIG>members,rand(),1,ascending,usergroup=4 AND adishown LIKE ', {CATID}, ',,,0,0,0,0</CONFIG>
That's what I tried, so that I can have a random list of the members of usergroup 4, who also have the current page's CATNAME in their 'adishown' member field.
How do you do that? The usergroup=4 works fine alone, but I can't figure out the rest.
Comments on ad rotating top list
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Hello Paul,
<CONFIG>members,rand(),1,ascending,usergroup=4 AND adishown LIKE ', {CATID}, ',,,0,0,0,0</CONFIG>
That's what I tried, so that I can have a random list of the members of usergroup 4, who also have the current page's CATNAME in their 'adishown' member field.
How do you do that? The usergroup=4 works fine alone, but I can't figure out the rest.
Thanks
David
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The condition has to be a MySQL condition. A LIKE in mysql is done as LIKE '%, {CATID}, %' (you're missing the %s)
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Thanks Paul.