<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>MultiSearch</title>
        <link>https://interactivetools.com/forum/forum-posts.php?MultiSearch-68856</link>
        <description></description>
        <pubDate>Fri, 15 May 2026 13:09:26 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;MultiSearch-68856" rel="self" type="application/rss+xml" />

                <item>
          <title>Re: [Jason] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2217439#post2217439</link>
          <description><![CDATA[Once again you've helped me a lot.<br /><br />Now I have to get the last step, extract images from the news that match the search.<br /><br /><br />Great! Thank you Jason.<br />]]></description>
          <pubDate>Tue, 14 Aug 2012 01:55:52 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2217439#post2217439</guid>
        </item>
                <item>
          <title>Re: [alissibronte] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2217430#post2217430</link>
          <description><![CDATA[Hi,<br /><br />multiSearch is set up to search multiple fields in multiple tables.  Looking at your current set up, you will be searching the &quot;text&quot; field in thome, and the title and text field in history and news.  If you need to search against more fields (ie, meta_description, preview_text, etc) you can add these to the searchFields array where needed.<br /><br />Try using _title instead of title, like this:<br /><br /><br /><code>&lt;?php foreach ($searchRows as $record): ?&gt; <br />   &lt;p&gt;&lt;a href=&quot;&lt;?php echo $record['_link']; ?&gt;&quot; title=&quot;&lt;?php echo htmlspecialchars($record['_title']); ?&gt;&quot;&gt;&lt;?php echo htmlspecialchars($record['_title']); ?&gt;&lt;/a&gt;&lt;/p&gt; <br />&lt;?php endforeach; ?&gt;</code><br /><br />Hope this helps<br />]]></description>
          <pubDate>Mon, 13 Aug 2012 11:06:09 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2217430#post2217430</guid>
        </item>
                <item>
          <title>Re: [Jason] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2217422#post2217422</link>
          <description><![CDATA[Hi guys,<br /><br />i'm trying to do a multisearch page but i can't understand how search fields works.<br /><br />Here is my code:<br /><code>//SEARCH CODE<br /><br />    $searchOptions = array(); <br />    $searchOptions['keywords'] = @$FORM['q']; <br />    $searchOptions['perPage'] = &quot;15&quot;; <br />    $searchOptions['debugSql'] = &quot;0&quot;; <br /><br />    $searchTables = array(); <br />    <br />    $searchTables['thome'] = array( <br />    'viewerUrl' =&gt; 'index.php', <br />    'titleField' =&gt; 'title', <br />    'summaryField' =&gt; 'text', <br />    'searchFields' =&gt; array('text'), <br />    ); <br />    <br />    $searchTables['history'] = array( <br />    'viewerUrl' =&gt; 'history.php', <br />    'titleField' =&gt; 'title', <br />    'summaryField' =&gt; 'text', <br />    'searchFields' =&gt; array('title','text'), <br />    ); <br />    <br />    $searchTables['news'] = array( <br />    'viewerUrl' =&gt; 'news.php', <br />    'titleField' =&gt; 'title', <br />    'summaryField' =&gt; 'text', <br />    'searchFields' =&gt; array('title','text'), <br />    ); <br />    <br />    list($searchRows, $searchDetails) = searchMultipleTables($searchTables, $searchOptions);<br />    <br />    $searchRow = @$searchRows[0];</code><br /><br /><code>&lt;form method=&quot;post&quot; action=&quot;/search.php&quot;&gt;<br />&lt;input type=&quot;text&quot; name=&quot;q&quot; value=&quot;&quot; /&gt;<br />&lt;input type=&quot;submit&quot; name=&quot;submit&quot; value=&quot;Search&quot; class=&quot;submit&quot; /&gt;<br />&lt;/form&gt;<br /><br />&lt;?php foreach ($searchRows as $record): ?&gt;<br />   &lt;p&gt;&lt;a href=&quot;&lt;?php echo $record['_link']; ?&gt;&quot; title=&quot;&lt;?php echo htmlspecialchars($record['title']); ?&gt;&quot;&gt;&lt;?php echo htmlspecialchars($record['title']); ?&gt;&lt;/a&gt;&lt;/p&gt;<br />&lt;?php endforeach; ?&gt;</code><br /><br /><br />My questions:<br /><br />Is possible to set form search field with multiple keywords?<br />e.x: &lt;input type=&quot;text&quot; name=&quot;preview_text,text,type,line,meta_description&quot; value=&quot;&quot; /&gt;<br />$searchOptions['keywords'] = @$FORM['preview_text,text,type,line,meta_description']; <br /><br />I dont understand how works these params:<br />'titleField' =&gt; 'title', <br />'summaryField' =&gt; 'text',<br /><br />I'm getting error Undefined index: title. Please help me a little.<br /><br />Thank you, regards!<b><br />]]></description>
          <pubDate>Mon, 13 Aug 2012 03:34:18 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2217422#post2217422</guid>
        </item>
                <item>
          <title>Re: [zick] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2217220#post2217220</link>
          <description><![CDATA[Hi Zick,<br /><br />There currently isn't any support for that in multiSearch.  However, if you needed to do that, you could filter out non-2nd Level records when outputting results since all 2nd level Records have a value of &quot;1&quot; in their &quot;depth&quot; field.<br /><br />Hope this helps<br />]]></description>
          <pubDate>Mon, 30 Jul 2012 00:16:22 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2217220#post2217220</guid>
        </item>
                <item>
          <title>Re: [Jason] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2217194#post2217194</link>
          <description><![CDATA[Is it possible to search a second tier category (excluding the first tier) using MultiSearch, thereby the search results only displays tier two category results and ignores the top tier categories?<br /><code>  $searchTables['news'] = array(<br />        'viewerUrl'       =&gt; 'news_details.php',<br />        'titleField'      =&gt; 'title',<br />        'summaryField'    =&gt; 'content',<br />        'searchFields'    =&gt;  array('title','content'),<br />	  <br />  $searchTables['business_listings'] = array(<br />        'viewerUrl'       =&gt; 'business_listing_details.php',<br />        'titleField'      =&gt; 'name',<br />        'summaryField'    =&gt; 'content',<br />        'searchFields'    =&gt;  array('name','content'),<br />	<b><span style="color:red">'categoryFormat'      =&gt; twolevel',</span></b><br />      );</code><br />]]></description>
          <pubDate>Thu, 26 Jul 2012 20:03:52 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2217194#post2217194</guid>
        </item>
                <item>
          <title>Re: [zick] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2213860#post2213860</link>
          <description><![CDATA[Hi,<br /><br />You should be able to get around that issue by putting something in the orderBy clause.  Try this:<br /><br /><code>list($imageRecords,$imageMetaData)=getRecords(array(  <br />        'tableName'       =&gt;      'uploads',  <br />        'allowSearch'     =&gt;      false,  <br />        'where'           =&gt;      &quot;tableName = 'photos' AND (LOWER(info1) LIKE '%&quot;.mysql_escape(strtolower(@$FORM['q'])).&quot;%' OR LOWER(info1) LIKE '%&quot;.mysql_escape(strtolower(@$FORM['q'])).&quot;%')&quot;,<br />	'orderBy'         =&gt;      &quot;`order`&quot;,<br />	'loadUploads'     =&gt;      false,<br />	'loadCreatedBy'   =&gt;      false,<br />      ));</code><br /><br />Hope this helps<br />]]></description>
          <pubDate>Sat, 12 Nov 2011 16:32:40 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2213860#post2213860</guid>
        </item>
                <item>
          <title>Re: [Jason] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2213849#post2213849</link>
          <description><![CDATA[Hey Jason,<br />I tired your solution, to search the upload info1 fields, but it's giving me a notice message:<br /><br /><code>list($imageRecords,$imageMetaData)=getRecords(array( <br />        'tableName'       =&gt;      'uploads', <br />        'allowSearch'     =&gt;      false, <br />        'where'           =&gt;      &quot;tableName = 'photos' AND (LOWER(info1) LIKE '%&quot;.mysql_escape(strtolower(@$FORM['q'])).&quot;%' OR LOWER(info1) LIKE '%&quot;.mysql_escape(strtolower(@$FORM['q'])).&quot;%')&quot;, <br />      ));</code><br /><br /><blockquote>Notice: Undefined index: listPageOrder in /home/content/00/1230000/html/cms/lib/viewer_functions.php on line 70 </blockquote><br /><br />Any suggestions on how to get this working?<br />]]></description>
          <pubDate>Thu, 10 Nov 2011 23:54:01 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2213849#post2213849</guid>
        </item>
                <item>
          <title>Re: [richo] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2213505#post2213505</link>
          <description><![CDATA[Hi Richo,<br /><br />The php.ini changes you're looking for are not on the CMS Builder level. They're on the web host level.<br /><br />The default upload size is usually limited to 2mb by the host to prevent misuse of their resources<br /><br />Ask your webhost to increase the the post_max_size and the upload_max_filesize to something like 60mb and that should cover you for videos and other large files as well.<br /><br />Most really good hosts will accommodate.<br /><br /><br />Hope that helps sort things out.<br /><br />Jerry Kornbluth<br />]]></description>
          <pubDate>Wed, 12 Oct 2011 19:20:21 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2213505#post2213505</guid>
        </item>
                <item>
          <title>Re: [zickey] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2207472#post2207472</link>
          <description><![CDATA[Hi Zickey,<br /><br />The image information for a picture is actually stored in the uploads table, not in the section with the upload field.  You could try something similar to this:<br /><br /><code>  list($imageRecords,$imageMetaData)=getRecords(array(<br />        'tableName'       =&gt;      'uploads',<br />        'allowSearch'     =&gt;      false,<br />        'where'           =&gt;      &quot;tableName = 'photos' AND (LOWER(info1) LIKE '%&quot;.mysql_escape(strtolower(@$FORM['q'])).&quot;%' OR LOWER(info1) LIKE '%&quot;.mysql_escape(strtolower(@$FORM['q'])).&quot;%')&quot;,<br />      ));</code><br /><br />Hope this helps<br />]]></description>
          <pubDate>Fri, 15 Oct 2010 11:20:20 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2207472#post2207472</guid>
        </item>
                <item>
          <title>Re: [zickey] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2207470#post2207470</link>
          <description><![CDATA[Is there a way to make this multi-search case insensitive?<br /><br /><blockquote>Dave,<br />In the code below, you'll see the last $searchTables is for searching information related to photos. I'd like to make my photo's upload &quot;info1 &amp; info2&quot; fields searchable, so people can search for photos based on the photo's title and caption. I've tried to get this work, but I'm doing something wrong. Can you shed a little light on what needs to be done to this code to get the &quot;info1 &amp; info2&quot; data I'm using in my photo title and captions to appear in the search form results.<br /><br />Thanks, Zick<br /><br />==========<br />&lt;?php header('Content-type: text/html; charset=utf-8'); ?&gt;<br />&lt;?php<br />  <br />  require_once &quot;/this/hosting/cmsbuilder/lib/viewer_functions.php&quot;;<br /> <br /> // begin search code<br />   list($search_this_siteRecords, $search_this_siteMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'search_this_site',<br />    'where'       =&gt; whereRecordNumberInUrl(1),<br />    'limit'       =&gt; '1',<br />  ));<br />  $search_this_siteRecord = @$search_this_siteRecords[0]; // get first record<br /><br />  // show error message if no matching record is found<br />  // if (!$search_this_siteRecord) {<br />  //  header(&quot;HTTP/1.0 404 Not Found&quot;);<br />  //  print &quot;Record not found!&quot;;<br />  //  exit;<br />  //}<br /><br />?&gt;<br />&lt;?php<br />	// search viewer code begins<br />      $searchOptions = array();<br />      $searchOptions['keywords'] = @$FORM['q'];<br />      $searchOptions['perPage']  = &quot;4&quot;;<br />      $searchOptions['debugSql'] = &quot;0&quot;;<br /><br />      $searchTables = array();<br />       <br />      $searchTables['house'] = array(<br />        'viewerUrl'       =&gt; 'house_details.php',<br />        'titleField'      =&gt; 'title',<br />        'summaryField'    =&gt; 'content',<br />        'searchFields'    =&gt;  array('title','content'),<br />      );<br />	  <br />	  $searchTables['building'] = array(<br />        'viewerUrl'       =&gt; 'building_details.php',<br />        'titleField'      =&gt; 'title',<br />        'summaryField'    =&gt; 'content',<br />        'searchFields'    =&gt;  array('title','content'),<br />      );<br />	  <br />	  $searchTables['photos'] = array(<br />        'viewerUrl'       =&gt; 'photos_details.php',<br />        'titleField'      =&gt; 'title',<br />        'summaryField'    =&gt; 'content',<br />        'uploadField'    =&gt; 'info1',<br />        'uploadField'    =&gt; 'info2',<br />        'searchFields'    =&gt;  array('title','content','info1','info2'),<br />      );<br /><br />      list($searchRows, $searchDetails) = searchMultipleTables($searchTables, $searchOptions);<br />	  // search viewer code ends<br />?&gt;<br />==========</blockquote><br />]]></description>
          <pubDate>Fri, 15 Oct 2010 01:59:50 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2207470#post2207470</guid>
        </item>
                <item>
          <title>Re: [zickey] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206248#post2206248</link>
          <description><![CDATA[Hi Zick,<br /><br />The fields associated with an uploaded image are actually stored in the uploads table, not in the section they're uploaded to.<br /><br />The field for title is stored in info1, caption is stored in info2.  Try doing a search on the uploads table for these fields.<br /><br />Hope this helps.<br />]]></description>
          <pubDate>Mon, 23 Aug 2010 12:22:11 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206248#post2206248</guid>
        </item>
                <item>
          <title>Re: [Dave] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206229#post2206229</link>
          <description><![CDATA[Dave,<br />In the code below, you'll see the last $searchTables is for searching information related to photos. I'd like to make my photo's upload &quot;info1 &amp; info2&quot; fields searchable, so people can search for photos based on the photo's title and caption. I've tried to get this work, but I'm doing something wrong. Can you shed a little light on what needs to be done to this code to get the &quot;info1 &amp; info2&quot; data I'm using in my photo title and captions to appear in the search form results.<br /><br />Thanks, Zick<br /><br />==========<br />&lt;?php header('Content-type: text/html; charset=utf-8'); ?&gt;<br />&lt;?php<br />  <br />  require_once &quot;/this/hosting/cmsbuilder/lib/viewer_functions.php&quot;;<br /> <br /> // begin search code<br />   list($search_this_siteRecords, $search_this_siteMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'search_this_site',<br />    'where'       =&gt; whereRecordNumberInUrl(1),<br />    'limit'       =&gt; '1',<br />  ));<br />  $search_this_siteRecord = @$search_this_siteRecords[0]; // get first record<br /><br />  // show error message if no matching record is found<br />  // if (!$search_this_siteRecord) {<br />  //  header(&quot;HTTP/1.0 404 Not Found&quot;);<br />  //  print &quot;Record not found!&quot;;<br />  //  exit;<br />  //}<br /><br />?&gt;<br />&lt;?php<br />	// search viewer code begins<br />      $searchOptions = array();<br />      $searchOptions['keywords'] = @$FORM['q'];<br />      $searchOptions['perPage']  = &quot;4&quot;;<br />      $searchOptions['debugSql'] = &quot;0&quot;;<br /><br />      $searchTables = array();<br />       <br />      $searchTables['house'] = array(<br />        'viewerUrl'       =&gt; 'house_details.php',<br />        'titleField'      =&gt; 'title',<br />        'summaryField'    =&gt; 'content',<br />        'searchFields'    =&gt;  array('title','content'),<br />      );<br />	  <br />	  $searchTables['building'] = array(<br />        'viewerUrl'       =&gt; 'building_details.php',<br />        'titleField'      =&gt; 'title',<br />        'summaryField'    =&gt; 'content',<br />        'searchFields'    =&gt;  array('title','content'),<br />      );<br />	  <br />	  $searchTables['photos'] = array(<br />        'viewerUrl'       =&gt; 'photos_details.php',<br />        'titleField'      =&gt; 'title',<br />        'summaryField'    =&gt; 'content',<br />        'uploadField'    =&gt; 'info1',<br />        'uploadField'    =&gt; 'info2',<br />        'searchFields'    =&gt;  array('title','content','info1','info2'),<br />      );<br /><br />      list($searchRows, $searchDetails) = searchMultipleTables($searchTables, $searchOptions);<br />	  // search viewer code ends<br />?&gt;<br />==========<br />]]></description>
          <pubDate>Sun, 22 Aug 2010 18:35:46 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206229#post2206229</guid>
        </item>
                <item>
          <title>Re: [Djulia] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196614#post2196614</link>
          <description><![CDATA[Hi Djulia<br /><br />My last post was a reply to someone else. Although, now that I check it again, Dave already replied to that one anyway.  You can see who I am replying to in the name of the post:<br /><br />Re: [Djulia] MultiSearch<br /><br />Anyway. I am not quite sure what you meant in your last post. Are you saying you would rather have the date fields on your search form set as text boxes?<br /><br />Let me know ;)<br />]]></description>
          <pubDate>Fri, 27 Mar 2009 16:53:24 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196614#post2196614</guid>
        </item>
                <item>
          <title>Re: [ross] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196608#post2196608</link>
          <description><![CDATA[Hi Ross, <br /><br />You are certain that the answer was for this post ? <br /><br />Excuse me, but I do not see the relationship with the function of research. <br /><br />You are certain that this modification on the server will mask this Mysql error ? <br /><br />Thanks, <br /><br />Djulia<br />]]></description>
          <pubDate>Fri, 27 Mar 2009 15:42:24 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196608#post2196608</guid>
        </item>
                <item>
          <title>Re: [richo] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196589#post2196589</link>
          <description><![CDATA[Hi John<br /><br />You'll actually need to ask your webhost to make changes in the php.ini file. Just send them and email and ask that the max upload size be increased to 8MB.<br /><br />Keep me up to date with how you are making out :).<br />]]></description>
          <pubDate>Fri, 27 Mar 2009 11:58:00 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196589#post2196589</guid>
        </item>
                <item>
          <title>Re: [ross] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196580#post2196580</link>
          <description><![CDATA[Hi Ross,<font size="2"> <br /><br />Thanks for your answer. <br /><br />In fact, it is our site of presentation and the user can make many tests.<br />The design is also very important and it is difficult to use your solution. <br /><br />Also, we perhaps will use JavaScript to make the checking. [:(] <br /><br />Djulia</font><br />]]></description>
          <pubDate>Thu, 26 Mar 2009 15:29:27 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196580#post2196580</guid>
        </item>
                <item>
          <title>Re: [Djulia] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196570#post2196570</link>
          <description><![CDATA[Hi<br /><br />From my experience, price searching always works better with drop downs. That way, you have way better control over the values your visitors can enter. Things like dollar signs and commas are always going to be a factor if you let them enter everything themselves.<br /><br />My recommendation is to convert these two text fields to drop down menus. <br /><br />That should clear everything up :).<br />]]></description>
          <pubDate>Thu, 26 Mar 2009 11:18:25 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196570#post2196570</guid>
        </item>
                <item>
          <title>Re: [ross] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196556#post2196556</link>
          <description><![CDATA[<font size="2">Hi Ross, <br /><br />Thanks for your answer. <br /><br />In fact I use a input text and it is impossible to prohibit the user from entering of the text. <br /><br />&lt;input type=&quot;text&quot; name=&quot;prix_min&quot; class=&quot;form_input&quot; /&gt; <br />&lt;input type=&quot;text&quot; name=&quot;prix_max&quot; class=&quot;form_input&quot; /&gt; <br /><br />Also, there would be a solution for to mask the Mysql error ? <br />To obtain an error message like : you must enter a value numeric. <br /></font><font size="2"><br />I tried to use error_reporting(0); but that function not. [:(] <br /><br />Thanks for your suggestion. <br /><br />Djulia</font><br />]]></description>
          <pubDate>Wed, 25 Mar 2009 12:40:17 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196556#post2196556</guid>
        </item>
                <item>
          <title>Re: [Djulia] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196552#post2196552</link>
          <description><![CDATA[Hi Djulia<br /><br />In a situation where you need to search for &quot;minimum&quot; or &quot;maximum&quot;, you are actually better off to leave it blank. That will have the effect you are looking for.  <br /><br />If you are using a form to get to this url, try adding a value=&quot;&quot; attribute to the option tags for minimum and maximum like this:<br /><br />&lt;option value=&quot;&quot;&gt;Minimum&lt;/option&gt;<br /><br />&lt;option value=&quot;&quot;&gt;Maximum&lt;/option&gt;<br /><br />Let me know if that makes sense :).<br />]]></description>
          <pubDate>Wed, 25 Mar 2009 10:54:51 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196552#post2196552</guid>
        </item>
                <item>
          <title>Re: [Dave] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196546#post2196546</link>
          <description><![CDATA[Thanks for your answer. <br /><br />I obtain this error if the value of <i>fieldname</i>_min and <i>fieldname</i>_max is not numeric. <br /><br />getRecords(my_table) MySQL Error: You have an error in your SQL syntax; <br />check the manual that corresponds to your MySQL server version for the right <br />syntax to use near ') AND (`price`+0 &lt;= )) AND my_table.hidden = 0 <br />ORDER BY price ASC LIM' at line 3 <br /><br />For example, this URL will cause the error : search.php?prix_min=<b>minimum</b>&amp;prix_max=<b>maximum</b> <br /><br />There is a possibility to remove this error message ? <br /><br />Thanks, <br /><br />Djulia<br />]]></description>
          <pubDate>Tue, 24 Mar 2009 14:57:28 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196546#post2196546</guid>
        </item>
                <item>
          <title>Re: [Djulia] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196536#post2196536</link>
          <description><![CDATA[Hi Djulia,<br /><br />No, unfortunately it won't.  It's because it generalizes all the fields from multiple tables and only provides basic keyword search features.<br />]]></description>
          <pubDate>Tue, 24 Mar 2009 12:45:11 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196536#post2196536</guid>
        </item>
                <item>
          <title>Re: [Dave] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2196520#post2196520</link>
          <description><![CDATA[<font size="2">Hi Dave, <br /><br />searchMultipleTables does not seem to work with fieldname_min or fieldname_min. <br /><br />You confirm ? <br /><br />Thanks for your answer. <br /><br />Djulia</font><br />]]></description>
          <pubDate>Tue, 24 Mar 2009 09:23:12 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2196520#post2196520</guid>
        </item>
                <item>
          <title>Re: [sev] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2194828#post2194828</link>
          <description><![CDATA[Hi sev,<br /><br />No, unfortunately multisearch doesn't support SEO urls or extra values in the url such as: <span style="color:red">my-title-</span>6.<br /><br />For all links, the number is what's used to look up the record.  So you can remove it but then you need to use something else to look up the value.  You could do something like this:<br /><br />page.php?title=About<br /><br />Or as a where option in the code:<br /><br />'where' =&gt; &quot; title = 'About' &quot;,<br /><br />Hope that helps!<br />]]></description>
          <pubDate>Thu, 18 Dec 2008 22:41:57 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2194828#post2194828</guid>
        </item>
                <item>
          <title>Re: [Dave] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2194809#post2194809</link>
          <description><![CDATA[hi guys<br />im enjoying learning what i can do with cmsb [;)]<br />hopefully a quick question for you...<br /><br />can this multisearch be used in conjunction with the seo friendly urls option &quot;filename fields&quot; in viewer urls of admin &gt;  section editors?<br /><br />i have the sitewide search multisearch.php working great but would ideally like the links to mirror what i have set up in the categories using the record title in the link eg mysite.com/viewer.php/my-title-6/<br /><br />also not just on the multisearch but on all links is there a way to remove the record number from the end and just refer to the record title?<br />or is the number needed somewhere? [crazy]<br /><br />thanks very much for your support]]></description>
          <pubDate>Thu, 18 Dec 2008 00:04:59 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2194809#post2194809</guid>
        </item>
                <item>
          <title>Re: [richo] MultiSearch</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2191796#post2191796</link>
          <description><![CDATA[Sometimes you can override those with an .htaccess file.  But the easiest is just to ask your host.<br /><br />You can see your current PHP settings under Admin &gt; General &gt; PHP Info (at the bottom of the page).<br /><br />The settings you want to check are:<br /><br />upload_max_filesize<br />post_max_size<br />max_input_time<br />max_execution_time<br /><br />Usually just asking your host is the simplest though.<br /><br />Hope that helps.<br />]]></description>
          <pubDate>Fri, 30 May 2008 14:31:33 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2191796#post2191796</guid>
        </item>
              </channel>
    </rss>
  