<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>Where help </title>
        <link>https://interactivetools.com/forum/forum-posts.php?Where-help-81312</link>
        <description></description>
        <pubDate>Mon, 07 Sep 2026 14:42:25 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;Where-help-81312" rel="self" type="application/rss+xml" />

                <item>
          <title>Where help </title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242027#post2242027</link>
          <description><![CDATA[<p>that worked. Thanks!</p>]]></description>
          <pubDate>Mon, 07 May 2018 14:07:26 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242027#post2242027</guid>
        </item>
                <item>
          <title>Where help </title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242026#post2242026</link>
          <description><![CDATA[<p>Okay it seems that multi value field contains extra spaces. Try replace explode() with this one: <span>preg_split</span>(<span>'/[\t]/'</span>, <span>trim</span>(<span>$page['related_sessions']</span>))</p>]]></description>
          <pubDate>Mon, 07 May 2018 13:24:27 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242026#post2242026</guid>
        </item>
                <item>
          <title>Where help </title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242025#post2242025</link>
          <description><![CDATA[<p>tried this...</p>
<p><code>$related_sessions = implode(',', explode("\t",$page['related_sessions']));</code></p>
<p><code>'where' =&gt; "num IN ($related_sessions)", </code></p>
<p>Got this...</p>
<p><code>SELECT SQL_CALC_FOUND_ROWS `sessions`.*<br />FROM `cms_sessions` as `sessions`<br /> WHERE (num IN (,1048,1047,)) AND `sessions`.hidden = 0 <br /> ORDER BY date_time DESC,location,type<br /> LIMIT 2MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1048,1047,)) AND `online_sessions`.hidden = 0 ORDER BY date_time DESC,location' at line 3</code></p>
]]></description>
          <pubDate>Mon, 07 May 2018 13:17:07 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242025#post2242025</guid>
        </item>
                <item>
          <title>Where help </title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242024#post2242024</link>
          <description><![CDATA[<p>Try this: $related_sessions = implode(',', <span>explode("\t",$page['related_sessions'])</span>)</p>]]></description>
          <pubDate>Mon, 07 May 2018 13:09:20 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242024#post2242024</guid>
        </item>
                <item>
          <title>Where help </title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242023#post2242023</link>
          <description><![CDATA[<p>Trying the following, but not working...</p>
<p><code>$related_sessions = explode("\t",$page['related_sessions']);</code></p>
<p>and...</p>
<p><code>'where' =&gt; "num IN ($related_sessions)", </code></p>
<p>getting this...</p>
<p><span>Notice: Array to string conversion in </span></p>]]></description>
          <pubDate>Mon, 07 May 2018 12:37:27 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242023#post2242023</guid>
        </item>
                <item>
          <title>Where help </title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242019#post2242019</link>
          <description><![CDATA[<p>Hi,</p>
<p>It seems your related_sessions field is a multi-select field. Try getting the related_sessions value csv string first by explode() and use "num IN ()" instead.</p>
<p>Let me know if you have any questions.</p>]]></description>
          <pubDate>Mon, 07 May 2018 10:16:57 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242019#post2242019</guid>
        </item>
                <item>
          <title>Where help </title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242018#post2242018</link>
          <description><![CDATA[<p>Not sure what i'm doing wrong here</p>
<p>two tables, DATES and SESSIONS.</p>
<p>DATES includes a list field that allows multiple SESSIONS to be selected - field name is related_sessions.</p>
<p>On the public DATES page, I'm trying to load all of the related_sessions</p>

<p><code> // load record from 'dates'<br /> list($date, $dateMetaData) = getRecords(array(<br /> 'tableName'   =&gt; 'dates',<br /> 'where'       =&gt; whereRecordNumberInUrl(0),<br /> 'loadUploads' =&gt; true,<br /> 'allowSearch' =&gt; false,<br /> 'limit'       =&gt; '1',<br /> ));<br /> $date = @$date[0]; // get first record<br /> if (!$date) { header('Location: /'); exit; }<br /><br /> // load records from 'sessions'<br /> list($related_sessions, $related_sessionsMetaData) = getRecords(array(<br /> 'tableName'   =&gt; 'sessions',<br />'where' =&gt; "num LIKE '%\t". $date['related_sessions'] ."\t%'" , <br /> 'loadUploads' =&gt; true,<br /> 'allowSearch' =&gt; false,<br /> ));<br /></code></p>
<p>with debug on:</p>
<p><code>SELECT SQL_CALC_FOUND_ROWS `sessions`.*<br />FROM `cms_sessions` as `sessions`<br /> WHERE (num LIKE '% 1048 1047 %') AND `sessions`.hidden = 0 <br /> ORDER BY date_time DESC,location,type</code></p>
<p>Not record are returned. </p>]]></description>
          <pubDate>Mon, 07 May 2018 09:31:31 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242018#post2242018</guid>
        </item>
              </channel>
    </rss>
  