Member
Member
edasque   02-10-2008, 17:41
#1

Now what tags are separate from the entity they're applied to and have their own table structure, what should the following query become:

$imageWhere = " AND " . prefix('images') . ".show=1 AND " .prefix('images').".tags NOT LIKE \"%no.random%\"";
Administrator
Administrator
acrylian   02-10-2008, 18:08
#2

Would you mind to tell us where you find that query or shall we search ourselves?..:-)

Member
Member
edasque   03-10-2008, 17:53
#3

Well, I had modified a Random Image piece of code so that it wouldn't display photos (and albums) that are tagged with no.random. That's so I could avoid displaying any of 500 pictures I took at the baseball game. I tag albums or photos that I don't want to be selected randomly with "no.random". I guess the query has to join that other table now, sql wizardry.

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.