<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>Search/filter question</title>
        <link>https://interactivetools.com/forum/forum-posts.php?Search-filter-question-80765</link>
        <description></description>
        <pubDate>Fri, 14 Aug 2026 08:32:49 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;Search-filter-question-80765" rel="self" type="application/rss+xml" />

                <item>
          <title>Search/filter question</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2239822#post2239822</link>
          <description><![CDATA[<p>Hi there.</p>
<p>You can build a custom query using values from the query string using $_REQUEST.</p>
<p>It could look something like this:</p>
<p><code>$customWHERE = "";<br /><br />$customWHERE =  "melt_type = ". mysql_escape(@$_REQUEST['melt_type']);<br />$customWHERE .= " OR melt_type = ". mysql_escape(@$_REQUEST['melt_type']);</code></p>
<p>And then in your getRecords, you would use something like this:</p>
<p><code>// load records from 'another_multi_section'<br /> list($another_multi_sectionRecords, $another_multi_sectionMetaData) = getRecords(array(<br />  'tableName' =&gt; 'another_multi_section',<br />  'loadUploads' =&gt; true,<br />  'allowSearch' =&gt; false,<br />  'where'       =&gt; $customWHERE ,<br /> ));</code></p>
<p>A couple notes:</p>
<p>1. Make sure you have "allowSearch" set to "False". If that's true, the search you get will be a composite of what's in the query string as well as the custom WHERE.</p>
<p>2. You can create your $customWHERE on a single line if you like. I broke my example into two lines so it's easier to read in a forum post.</p>
<p>Does that all make sense?</p>
<p>Let me know any questions.</p>
<p>Thanks!</p>]]></description>
          <pubDate>Mon, 21 Nov 2016 13:53:06 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2239822#post2239822</guid>
        </item>
                <item>
          <title>Search/filter question</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2239806#post2239806</link>
          <description><![CDATA[<p>I am familiar and comfortable with the custom WHERE, but I'm not sure how to utilize it in this situation. How would I inject in custom criteria for the WHERE from the URL? Attached is a screen grab of my page, in case that's helpful.  </p>]]></description>
          <pubDate>Fri, 18 Nov 2016 08:01:27 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2239806#post2239806</guid>
        </item>
                <item>
          <title>Search/filter question</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2239799#post2239799</link>
          <description><![CDATA[<p>Hi there.</p>
<p>Thanks for posting.</p>
<p>What you will need to do is create a custom "WHERE" and use that to filter the results. </p>
<p>The custom "WHERE" will be where you can use the "OR" searches:</p>
<p><code>"where" =&gt; "melt_type = 1 OR melt_type = 2 OR melt_type = 3"</code></p>
<p>How comfortable are you with custom "WHERE"?</p>
<p>Let me know what you think.</p>
<p>Thanks!</p>]]></description>
          <pubDate>Thu, 17 Nov 2016 15:18:11 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2239799#post2239799</guid>
        </item>
                <item>
          <title>Search/filter question</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2239796#post2239796</link>
          <description><![CDATA[<p>Any thoughts on this?</p>]]></description>
          <pubDate>Thu, 17 Nov 2016 14:14:59 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2239796#post2239796</guid>
        </item>
                <item>
          <title>Search/filter question</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2239790#post2239790</link>
          <description><![CDATA[<p>I am working a list filter for a client and I'm not sure how to accomplish something.</p>
<p>I have a Section (grades) that includes a multl-value checkbox list (melt_types). In the CMS the administrator can select as many melt_types as they want for each grade. </p>
<p>On the live site, I want the site users to be able to filter the list of grades by as many melt_types as they want.</p>
<p>I have filtering via the URL working one for melt_type...<br />/grades.php?melt_type=1</p>
<p>And I tried this, but it doesn't quite work, because it filters down to the grades that have both melt types selected...<br />/grades.php?melt_type=1&amp;melt_type=2</p>
<p>I need a method that results in an OR condition, not AND.</p>
<p>Possible? </p>]]></description>
          <pubDate>Thu, 17 Nov 2016 05:44:26 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2239790#post2239790</guid>
        </item>
              </channel>
    </rss>
  