<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title></title>
        <link>https://interactivetools.com/forum/forum-search.php?k=user%3Agcod</link>
        <description></description>
        <pubDate>Sat, 18 Apr 2026 11:06:36 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-search.php?k=user%3Agcod&amp;rss=1" rel="self" type="application/rss+xml" />

                <item>
          <title>Re: [Dave] Login credential without encryption</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2213450#post2213450</link>
          <description><![CDATA[Thanks Dave for your quick answer.<br /><br />I'm afraid the version of CMS builder (1.31) I've got doesn't have those setting in the under: Admin &gt; General.<br /><br />Any other idea?<br />]]></description>
          <pubDate>Sat, 08 Oct 2011 19:14:29 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2213450#post2213450</guid>
        </item>
                <item>
          <title>Login credential without encryption</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2213448#post2213448</link>
          <description><![CDATA[Hi,<br /><br />One of my clients' gateway provider is going to charge them $25.00 extra per month because the login credentials are not encrypted.<br /><br />Is there a way to mask or add encryption to the login areas of the app?<br /><br />Thanks!<br /><br />GaB<br />]]></description>
          <pubDate>Sat, 08 Oct 2011 10:06:31 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2213448#post2213448</guid>
        </item>
                <item>
          <title>Re: [zip222] Not Show section when there is no records</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206660#post2206660</link>
          <description><![CDATA[It's working, thanks for you help.<br /><br />Gab<br />]]></description>
          <pubDate>Thu, 09 Sep 2010 09:14:59 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206660#post2206660</guid>
        </item>
                <item>
          <title>Re: [zip222] Not Show section when there is no records</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206657#post2206657</link>
          <description><![CDATA[Here is my code:<br /><code>&lt;?php<br />  require_once &quot;/home/jeftay6/vin.com/cmsAdmin/lib/viewer_functions.php&quot;;<br />    <br />  list($home_pageRecords, $home_pageMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'home_page',<br />    'where'       =&gt; whereRecordNumberInUrl(1),<br />    'limit'       =&gt; '1',<br />  ));  <br />  $home_pageRecord = @$home_pageRecords[0];<br />  <br />  list($winesRecords, $winesMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'wines',<br />    'limit'       =&gt; '5',<br />  ));<br />  <br />  list($featured_articlesRecords, $featured_articlesMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'featured_articles',<br />    'limit'       =&gt; '5',    <br />  ));<br />  <br />  list($about_usRecords, $about_usMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'about_us',<br />    'where'       =&gt; whereRecordNumberInUrl(1),<br />    'limit'       =&gt; '1',<br />  ));<br />   $about_usRecord = @$about_usRecords[0];<br />   <br />   list($listes_de_produitsRecords, $listes_de_produitsMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'listes_de_produits',<br />    'where'       =&gt; whereRecordNumberInUrl(1),<br />    'limit'       =&gt; '1',<br />  ));<br />  $listes_de_produitsRecord = @$listes_de_produitsRecords[0];<br /><br />   <br />  $page = 'home'; <br />?&gt;<br /><br /><br />&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot; &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;&gt;<br />&lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;<br />&lt;head&gt;<br />&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=utf-8&quot; /&gt;<br />&lt;title&gt;&lt;?php echo $home_pageRecord['page_title'] ?&gt;&lt;/title&gt;<br />&lt;meta name=&quot;Description&quot; content=&quot;&lt;?php echo $home_pageRecord['meta_description'] ?&gt;&quot; /&gt;<br />&lt;meta name=&quot;KeyWords&quot; content=&quot;&lt;?php echo $home_pageRecord['meta_keywords'] ?&gt;&quot; /&gt;<br />&lt;link rel=&quot;shortcut icon&quot; href=&quot;/images/vin.ico&quot;&gt;<br />&lt;link rel=&quot;stylesheet&quot; href=&quot;/css/style.css&quot; type=&quot;text/css&quot; media=&quot;screen&quot; /&gt;<br /><br />&lt;script src=&quot;/js/jquery.v1.4.2.js&quot; type=&quot;text/javascript&quot; charset=&quot;utf-8&quot;&gt;&lt;/script&gt;<br />&lt;!--[if lte IE 6]&gt;<br />&lt;script src=&quot;/js/pngfix/supersleight-min.js&quot; type=&quot;text/javascript&quot; charset=&quot;utf-8&quot;&gt;&lt;/script&gt;<br />&lt;![endif]--&gt;<br /><br />&lt;!-- Slider --&gt;<br />&lt;link rel=&quot;stylesheet&quot; href=&quot;/css/slider.css&quot; type=&quot;text/css&quot; media=&quot;screen&quot; /&gt;<br />&lt;script src=&quot;/js/jquery.easing.1.2.js&quot; type=&quot;text/javascript&quot; charset=&quot;utf-8&quot;&gt;&lt;/script&gt;<br />&lt;script src=&quot;/js/jquery.anythingslider.js&quot; type=&quot;text/javascript&quot; charset=&quot;utf-8&quot;&gt;&lt;/script&gt;<br /><br />&lt;script type=&quot;text/javascript&quot;&gt;<br />    <br />        function formatText(index, panel) {<br />          return index + &quot;&quot;;<br />        }<br />    <br />        $(function () {<br />        <br />            $('.anythingSlider').anythingSlider({<br />                easing: &quot;easeInOutExpo&quot;,        // Anything other than &quot;linear&quot; or &quot;swing&quot; requires the easing plugin<br />                autoPlay: false,                 // This turns off the entire FUNCTIONALY, not just if it starts running or not.<br />                delay: 3000,                    // How long between slide transitions in AutoPlay mode<br />                startStopped: false,            // If autoPlay is on, this can force it to start stopped<br />                animationTime: 600,             // How long the slide transition takes<br />                hashTags: true,                 // Should links change the hashtag in the URL?<br />                buildNavigation: true,          // If true, builds and list of anchor links to link to each slide<br />                pauseOnHover: true,             // If true, and autoPlay is enabled, the show will pause on hover<br />                startText: &quot;Go&quot;,             // Start text<br />                stopText: &quot;Stop&quot;,               // Stop text<br />                navigationFormatter: formatText       // Details at the top of the file on this use (advanced use)<br />            });<br />            <br />            $(&quot;#slide-jump&quot;).click(function(){<br />                $('.anythingSlider').anythingSlider(6);<br />            });<br />            <br />        });<br />&lt;/script&gt;<br /><br />&lt;!-- Slider end --&gt;<br /><br />&lt;/head&gt;<br /><br />&lt;body&gt;<br />&lt;div id=&quot;wrap&quot;&gt;<br />    &lt;?php include ($_SERVER['DOCUMENT_ROOT'] . '/includes/header.php'); ?&gt;<br />      &lt;div class=&quot;anythingSlider&quot;&gt;        <br />          &lt;div class=&quot;wrapper&quot;&gt;<br />            &lt;ul class=&quot;wineinfo&quot;&gt;            <br />            &lt;?php foreach ($featured_articlesRecords as $record): ?&gt;<br />            &lt;?php if ($record['active'] == 1): ?&gt; <br />              &lt;li class=&quot;containerarticles&quot;&gt;<br />                  &lt;div class=&quot;winepic&quot;&gt;<br />                    &lt;?php foreach ($record['image'] as $upload): ?&gt;<br />                        &lt;img src=&quot;&lt;?php echo $upload['urlPath'] ?&gt;&quot; width=&quot;433&quot; height=&quot;313&quot; alt=&quot;&lt;?php echo $record['page_title'] ?&gt;&quot; align=&quot;left&quot; /&gt;<br />                        &lt;?php break; ?&gt; <br />                    &lt;?php endforeach ?&gt;<br />                &lt;/div&gt;<br />                  &lt;div class=&quot;article&quot;&gt;<br />                    &lt;h2&gt;&lt;a href=&quot;&lt;?php echo $record['_link'] ?&gt;&quot;&gt;&lt;?php echo $record['page_title'] ?&gt;&lt;/a&gt;&lt;/h2&gt;<br />                    &lt;p&gt;&lt;?php echo $record['summary'] ?&gt;&lt;/p&gt;<br />                    &lt;a href=&quot;&lt;?php echo $record['_link'] ?&gt;&quot;&gt;&lt;img width=&quot;110&quot; height=&quot;28&quot; alt=&quot;Learn More&quot; src=&quot;/images/more.png&quot;&gt;&lt;/a&gt;                    <br />                &lt;/div&gt;              <br />              &lt;/li&gt;<br />              &lt;?php endif ?&gt;<br />              &lt;?php endforeach ?&gt;    <br />            &lt;/ul&gt;        <br />          &lt;/div&gt;          <br />        &lt;/div&gt; &lt;!-- END AnythingSlider --&gt;<br />    &lt;div id=&quot;homemain&quot;&gt;<br />        &lt;h1&gt;&lt;?php echo $about_usRecord['title'] ?&gt;&lt;/h1&gt;<br />        &lt;?php echo $about_usRecord['summary'] ?&gt;<br />        &lt;a href=&quot;/apropos.php&quot;&gt;&lt;img src=&quot;/images/more.png&quot; width=&quot;110&quot; height=&quot;28&quot; alt=&quot;Learn More&quot; /&gt;&lt;/a&gt;<br />   &lt;h2 id=&quot;press&quot;&gt;Blog&lt;/h2&gt;<br />         &lt;ul id=&quot;danslapress&quot;&gt;<br />            &lt;?php<br />                      include ($_SERVER['DOCUMENT_ROOT'] . '/rss_feeds/rssclass.php');<br />                      $feedlist = new rss('http://192.168.1.1/blog/?feed=rss2');<br />                      echo $feedlist-&gt;display(3,&quot;Blog&quot;);    <br />            ?&gt;            <br />        &lt;/ul&gt;        <br />    &lt;/div&gt;&lt;!-- homemain end --&gt;<br />    &lt;div id=&quot;column&quot;&gt;<br />        &lt;?php if($winesRecords) : ?&gt; <br />        &lt;h2&gt;Les nouveaux arrivages&lt;/h2&gt;<br />        &lt;ul class=&quot;narrivage&quot;&gt;<br />        &lt;?php foreach ($winesRecords as $record): ?&gt;<br />            &lt;?php if ($record['nouveaux_arrivages'] == 1): ?&gt; <br />            &lt;li&gt;&lt;a href=&quot;&lt;?php echo $record['_link'] ?&gt;&quot;&gt;&lt;?php echo $record['page_title'] ?&gt;&lt;/a&gt;&lt;/li&gt;<br />            &lt;?php endif ?&gt;<br />        &lt;?php endforeach ?&gt;            <br />        &lt;/ul&gt;        <br />        &lt;a href=&quot;/nouveaux-arrivages.php&quot; class=&quot;narrivages&quot;&gt;&lt;img src=&quot;/images/view-all-new-arrivals.png&quot; alt=&quot;Voir les nouveaux arrivages&quot; width=&quot;186&quot; height=&quot;28&quot; /&gt;&lt;/a&gt;    <br />        &lt;?php endif; ?&gt;   <br />      &lt;div id=&quot;follow&quot;&gt;<br />            &lt;h2&gt;Suivez-nous...&lt;/h2&gt;<br />            &lt;a href=&quot;https://twitter.com/vin&quot;&gt;&lt;img src=&quot;/images/twitter-btn.png&quot; alt=&quot;Suivez nous sur Twitter&quot; width=&quot;154&quot; height=&quot;61&quot; /&gt;&lt;/a&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;a href=&quot;http://www.facebook.com/pages/Vins&quot;&gt;&lt;img src=&quot;/images/facebook-btn.png&quot; alt=&quot;Suivez nous sur Facebook&quot; width=&quot;154&quot; height=&quot;61&quot; /&gt;&lt;/a&gt;<br />            &lt;h5&gt;Inscription infolettre&lt;/h5&gt;<br />            &lt;p&gt;J'aimerais recevoir l'infolettre de Vin!&lt;br /&gt;<br />En tant que client privilÃ©giÃ© de Vin, vous serez informÃ© des nouveaux arrivages, des Ã©vÃ©nements spÃ©ciaux, dÃ©gustations et bien plus encore...&lt;br /&gt;&lt;/p&gt;<br />            &lt;iframe height=&quot;90&quot; allowTransparency=&quot;true&quot; frameborder=&quot;0&quot; scrolling=&quot;no&quot; style=&quot;width:100%;border:none&quot; src=&quot;/machform/embed.php?id=1&quot; title=&quot;Inscription Newsletter&quot;&gt;&lt;/iframe&gt;<br />            &lt;?php include ($_SERVER['DOCUMENT_ROOT'] . '/includes/listeproduits.php'); ?&gt;<br />        &lt;/div&gt;<br />    &lt;/div&gt;&lt;!-- column end --&gt;<br />    &lt;?php include ($_SERVER['DOCUMENT_ROOT'] . '/includes/footer.php'); ?&gt;<br />&lt;/div&gt; &lt;!-- wrap end --&gt;<br />&lt;/body&gt;<br />&lt;/html&gt;</code><br />]]></description>
          <pubDate>Thu, 09 Sep 2010 08:42:15 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206657#post2206657</guid>
        </item>
                <item>
          <title>Re: [zip222] Not Show section when there is no records</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206655#post2206655</link>
          <description><![CDATA[My bad, let me reformulate.<br /><br />There are records in the winetable, but I only show the ones that has a value &quot;1&quot; in the for the column &quot;nouveaux arrivages&quot;.<br /><br />If there are no wines with the value &quot;1&quot; in the &quot;nouveaux arrivages&quot; column I'd like to not show the section.<br /><br />Let me know if it's clearer.<br /><br />Thanks.<br />]]></description>
          <pubDate>Thu, 09 Sep 2010 08:22:22 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206655#post2206655</guid>
        </item>
                <item>
          <title>Re: [Damon] Not Show section when there is no records</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206647#post2206647</link>
          <description><![CDATA[Doesn't work :(<br /><br />Should I change something at the top?<br /><br /><code>  list($winesRecords, $winesMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'wines',<br />	'limit'       =&gt; '5',<br />  ));</code><br />]]></description>
          <pubDate>Wed, 08 Sep 2010 17:52:31 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206647#post2206647</guid>
        </item>
                <item>
          <title>[Solved] Not Show section when there is no records</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206557#post2206557</link>
          <description><![CDATA[Hi,<br /><br />I have a section on a page and I want it to not show if there is no records in the winesRecords table (I mean the all shabang: the h2, open ul and the close ul):<br /><br /><code>&lt;h2&gt;Les nouveaux arrivages&lt;/h2&gt;<br />        &lt;ul class=&quot;narrivage&quot;&gt;<br />        &lt;?php foreach ($winesRecords as $record): ?&gt;<br />        	&lt;?php if ($record['nouveaux_arrivages'] == 1): ?&gt; <br />            &lt;li&gt;&lt;a href=&quot;&lt;?php echo $record['_link'] ?&gt;&quot;&gt;&lt;?php echo $record['page_title'] ?&gt;&lt;/a&gt;&lt;/li&gt;<br />            &lt;?php endif ?&gt;<br />        &lt;?php endforeach ?&gt;<br />        	<br />        &lt;/ul&gt;</code><br /><br />Any ideas?<br /><br />Thanks!<br />]]></description>
          <pubDate>Sun, 05 Sep 2010 13:03:54 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206557#post2206557</guid>
        </item>
                <item>
          <title>Re: [Jason] Link to an other table</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2205667#post2205667</link>
          <description><![CDATA[I should have known that. <br /><br />Thanks!<br />]]></description>
          <pubDate>Mon, 26 Jul 2010 20:10:54 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2205667#post2205667</guid>
        </item>
                <item>
          <title>Link to an other table</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2205595#post2205595</link>
          <description><![CDATA[Hi,<br /><br />In know my title is shitty but I can't find a good one. (change it if needed).<br /><br />Here is my problem.<br /><br />I have a page with a product (a wine) that has a producer which is listed in the backend from an other table (producer table).<br /><br />On this wine page I'm showing the wine AND I'm listing all the other wines that has the same producer.<br /><br />The question is simple: I'd like to link back the producer name, in the list of wine with the same producer, to the producer page.<br /><br />I attached the code of the page.<br /><br />Thanks and let me know if you have questions.<br /><br />GaB<br />]]></description>
          <pubDate>Thu, 22 Jul 2010 12:32:56 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2205595#post2205595</guid>
        </item>
                <item>
          <title>Re: [yusuke] Install WordPress with CMS Builder ?</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204367#post2204367</link>
          <description><![CDATA[I personally had some problem with Wordpress, I tried to have a list from CMS Builder in the side column but WP wouldn't allow it (and gave an error). <br />I didn't digg a lot though, I Iframed the content and it was fine (the content was listed on 3 other pages I didn't it here too for SEO).<br />]]></description>
          <pubDate>Wed, 19 May 2010 11:16:25 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204367#post2204367</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204366#post2204366</link>
          <description><![CDATA[Awesome! Thanks a lot for your help Jason. <br /><b>Interactivetools rocks!</b><br />]]></description>
          <pubDate>Wed, 19 May 2010 10:43:24 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204366#post2204366</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204347#post2204347</link>
          <description><![CDATA[Hi,<br /><br />Here is the link to the page: http://69.163.236.206/produits.php<br /><br />Thanks.<br />]]></description>
          <pubDate>Tue, 18 May 2010 17:25:00 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204347#post2204347</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204266#post2204266</link>
          <description><![CDATA[Here you go.<br /><br />Thanks.<br />]]></description>
          <pubDate>Mon, 17 May 2010 12:38:52 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204266#post2204266</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204261#post2204261</link>
          <description><![CDATA[Nope it doesn't fix it.<br />]]></description>
          <pubDate>Mon, 17 May 2010 12:07:48 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204261#post2204261</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204256#post2204256</link>
          <description><![CDATA[I still get the same message <br /><code>Notice: Use of undefined constant winesRecords - assumed 'winesRecords' in /home/jeftay6/vinsbalthazard.com/produits.php on line 151</code><br /><br />I can't find what I'm doing wrong, here is my code:<br /><code>&lt;?php if($_REQUEST) : ?&gt; <br />       &lt;?php if(!winesRecords): ?&gt; <br />          &lt;tr&gt;      	<br />            &lt;td colspan=&quot;7&quot; class=&quot;norecords&quot;&gt;Aucun vin n'a été trouvé.&lt;/td&gt;<br />          &lt;/tr&gt;<br />          &lt;?php else: ?&gt;<br />              &lt;?php foreach ($winesRecords as $record): ?&gt;      <br />              &lt;tr&gt;      	<br />                &lt;td class=&quot;&lt;?php if ($record['couleur'] == 'Blanc'): ?&gt;white&lt;?php endif; ?&gt;&lt;?php if ($record['couleur'] == 'Rouge'): ?&gt;red&lt;?php endif; ?&gt;&lt;?php if ($record['couleur'] == 'Rosee'): ?&gt;rosee&lt;?php endif; ?&gt;&quot;&gt;&amp;nbsp;&lt;/td&gt;<br />                &lt;td&gt;&lt;?php echo $record['producer'] ?&gt;&lt;/td&gt;<br />                &lt;td&gt;&lt;?php echo $record['page_title'] ?&gt;&lt;/td&gt;<br />                &lt;td&gt;&lt;?php echo $record['country'] ?&gt;&lt;/td&gt;<br />                &lt;td&gt;&lt;?php echo $record['year'] ?&gt;&lt;/td&gt;<br />                &lt;td&gt;&lt;?php echo $record['origin'] ?&gt;&lt;/td&gt;<br />                &lt;td&gt;&lt;a href=&quot;&lt;?php echo $record['_link'] ?&gt;&quot;&gt;&lt;img src=&quot;/images/more.png&quot; width=&quot;95&quot; height=&quot;28&quot; alt=&quot;Voir vin&quot;/&gt;&lt;/a&gt;&lt;/td&gt;        <br />              &lt;/tr&gt;<br />              &lt;?php endforeach ?&gt;<br />          &lt;?php endif ?&gt;     <br />       &lt;?php endif ?&gt;</code><br />]]></description>
          <pubDate>Mon, 17 May 2010 11:43:40 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204256#post2204256</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204253#post2204253</link>
          <description><![CDATA[Hi Jason,<br /><br />It works! I can now search for a wine name.<br /><br />For the second piece of code, where should I put it exactly? I'm getting the following error:<br /><code>Notice: Use of undefined constant winesRecords - assumed 'winesRecords' in /home/jeftay6/vinsbalthazard.com/produits.php on line 151 </code><br /><br />I tried to put it between the &lt;?php foreach ($winesRecords as $record): ?&gt; and &lt;?php endforeach ?&gt; and I try between &lt;?php if($_REQUEST) : ?&gt;  and the &lt;?php endif ?&gt;.<br /><br />Thanks.<br />]]></description>
          <pubDate>Mon, 17 May 2010 11:25:53 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204253#post2204253</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204226#post2204226</link>
          <description><![CDATA[The name of the field in the wines table that store the wine's name is &quot;title&quot;.<br /><br />The wines table still pose problem.<br /><br />The code to search the partial name for producer works, thanks.<br /><br />We're getting close.<br />]]></description>
          <pubDate>Fri, 14 May 2010 17:55:55 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204226#post2204226</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204219#post2204219</link>
          <description><![CDATA[It's <i>working</i> only if I remove &quot;cepage&quot; (which right now is an empty table which would explain the error I suppose) and &quot;wines&quot; (which has a title).<br /><br />I'd like the user to be able to type a wine name and find it.<br /><br />If the user doesn't type the full producer name he won't get any result, is there a way to fix this? Display all the producer that has the keyword entered in their name (I'd like to have the same for wine too)<br /><br />Last question, when you don't have any result can I display a message?<br /><br />Thanks for your help and patience Jason.<br />]]></description>
          <pubDate>Fri, 14 May 2010 16:58:40 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204219#post2204219</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204215#post2204215</link>
          <description><![CDATA[I removed cepage and wines (wine gave the same error as cepage) a search with a year works (try 2008), but if I enter a producer name (one word or multiple) or country or a region the page crash.<br /><br />For portugal for exemple:<br /><code>MySQL Error: Unknown column 'portugal' in 'where clause'</code><br />]]></description>
          <pubDate>Fri, 14 May 2010 16:32:58 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204215#post2204215</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204212#post2204212</link>
          <description><![CDATA[Jason, <br /><br />it doesn't seems to work.<br /><br />Added your line of code (plus the wines) and change the form name to &quot;title&quot; and I get an error: <br /><br /><code>MySQL Error: Unknown column 'cepage' in 'where clause'</code><br /><br />The drop down search doesn't work any more.<br /><br />I attached my page.<br />]]></description>
          <pubDate>Fri, 14 May 2010 15:39:00 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204212#post2204212</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204181#post2204181</link>
          <description><![CDATA[Hi Jason,<br /><br />In the example you gave me the name of the input is the same as the one I putted. Not sure what you meant by that. Did you mean this?<br /><br /><code>&lt;input name=&quot;title&quot; type=&quot;text&quot;/&gt;</code><br /><br />Because this doesn't work.<br /><br />For the results to not show if a search is not done your &lt;?php if($_REQUEST) : ?&gt;  is perfect, thanks.<br /><br />The search only show wines; the region, country, producer, year, cepage tables are used in the wine section (as drop downs).<br /><br />When I do a search I'd like to display all the wines that has the keyword in any of those table.<br /><br />Right now it's working but my drop down (what I call the drop down search) is affected by the search and only display the value that fit the previous search.<br /><br />Do you have an idea how to fix that?<br /><br />Thanks.<br />]]></description>
          <pubDate>Fri, 14 May 2010 10:45:06 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204181#post2204181</guid>
        </item>
                <item>
          <title>Re: [gcod] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204160#post2204160</link>
          <description><![CDATA[Ok after reading for a while I did make it works using the following code:<br /><br /><code>&lt;form name=&quot;search&quot; method=&quot;GET&quot; action=&quot;/produits.php&quot;&gt;<br />            &lt;input name=&quot;region,country,wines,producer,year,cepage,wine&quot; type=&quot;text&quot;/&gt; <br />            &lt;select name=&quot;price_range&quot;&gt;<br />                &lt;option value=&quot;&quot; selected=&quot;selected&quot;&gt;--- Par Prix ---&lt;/option&gt;<br />                &lt;?php foreach ($price_rangeRecords as $record): ?&gt;<br />                &lt;option value=&quot;&lt;?php echo $record['num'] ?&gt;&quot;&gt;&lt;?php echo $record['title'] ?&gt;&lt;/option&gt;<br />                &lt;?php endforeach ?&gt;<br />            &lt;/select&gt; <br />            &lt;input name=&quot;Recherchez&quot; type=&quot;image&quot; src=&quot;/images/search-btn.jpg&quot; /&gt; &lt;span&gt;OU&lt;/span&gt; &lt;a href=&quot;/produits.php?price_range=&quot;&gt;&gt;&gt; Voir tous les vins&lt;/a&gt;<br />&lt;/form&gt;</code><br /><br />Now I need to know how to prevent the drop down search to be affected by a previous search (make them display all the values all the time) and how to start with my results empty (and how to display all the wines when the user click the &quot;Voir tous les vins&quot; link.<br /><br />Thanks!<br />]]></description>
          <pubDate>Thu, 13 May 2010 18:25:23 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204160#post2204160</guid>
        </item>
                <item>
          <title>Re: [Donna] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204157#post2204157</link>
          <description><![CDATA[Hi Donna,<br /><br />I applied your change and It didn't change much.<br />Though I realized that when I select an item in the country drop down, the page refresh and display the corresponding wines but the producer drop down now only show the producer that has wines in the country. Any idea why?<br /><br />I'm still stuck for the text field search witht he price range drop down,<b>Jason</b> did you find anything new? I'll spend some time again tonight digging the forum to find some answers.<br /><br />Any solution on how to not show by default all the wines and what I should put on the &quot;Voir tous les vins&quot; link to show them all?<br /><br />Thanks for you help guys.<br />]]></description>
          <pubDate>Thu, 13 May 2010 15:57:55 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204157#post2204157</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204111#post2204111</link>
          <description><![CDATA[Hi Jason,<br /><br />It doesn't work. <br /><br />After typing a value that you can find in one of the table (portugal or rioja) and hitting the search button, no value is displayed and the search drop down are all empty by the producer one.<br /><br />No sure what is going on here.<br />]]></description>
          <pubDate>Wed, 12 May 2010 12:45:32 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204111#post2204111</guid>
        </item>
                <item>
          <title>Re: [Jason] Search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204095#post2204095</link>
          <description><![CDATA[Hi Jason,<br /><br />For each of them the fields name are <b>title</b>.<br /><br />I'm not sure what you want for the php page. I can give you the latest version of the page which include the text field and the drop down for the price range but the text field is connected to nothing right now.<br /><br />Let me know and thanks for your help.<br />]]></description>
          <pubDate>Tue, 11 May 2010 21:58:09 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204095#post2204095</guid>
        </item>
              </channel>
    </rss>
  