ANDing multiple values in a field

[umetkaran]

(09-24-2015 03:12 AM)ln_e Wrote:  Thanks for the help anyway!

I think I've figured it out in the meantime, although would still like to know if there is a less hacky solution.

For anyone looking to do something similar, this is the part that handles multiple select queries in xt_forumdhooks.php

Quote:$qstr .= $qor.$cfield.' LIKE "'.$qlpre.xthreads_forumdisplay_filter_parselike($v, $filtermode).$qlpost.'"';
if(!$qor) $qor = ' OR ';

This is where the multiple values are ORed together, you can just duct tape it with an AND:

Quote:$qstr .= $qor.$cfield.' LIKE "'.$qlpre.xthreads_forumdisplay_filter_parselike($v, $filtermode).$qlpost.'"';
if(!$qor) $qor = ' AND ';

Not a pretty solution by any means, but it does the job.

(09-29-2015 12:24 PM)ZiNgA BuRgA Wrote:  Your solution is probably the best there is.  I'm not sure if there's a nice way to toggle OR/AND, so I picked the most likely to be used, OR.

i try this way, but not work. & filter mode i changed (exact macth, contains, wildcard)

for simple choosing (with little choice), i try RateU solution.