<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>Choose from a list</title>
        <link>https://interactivetools.com/forum/forum-posts.php?Choose-from-a-list-81577</link>
        <description></description>
        <pubDate>Mon, 15 Jun 2026 00:31:22 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;Choose-from-a-list-81577" rel="self" type="application/rss+xml" />

                <item>
          <title>Choose from a list</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2243107#post2243107</link>
          <description><![CDATA[<p>I think i fixed the problem. Just a pair of '' were missing. </p>
<pre class="language-markup"><code>SELECT CONCAT (fullname, " ", name)
  FROM `&lt;?php echo $TABLE_PREFIX ?&gt;accounts`
  WHERE hospital='&lt;?php echo $CURRENT_USER['hospital'] ?&gt;'
  ORDER BY fullname</code></pre>]]></description>
          <pubDate>Fri, 01 Mar 2019 12:44:21 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2243107#post2243107</guid>
        </item>
                <item>
          <title>Choose from a list</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2243103#post2243103</link>
          <description><![CDATA[<p>Hi</p>
<p>I am writing the following code in the List options of a field and it does not work.  Can I have some help?</p>
<p>(I assume that the problem would be at the <em><strong>&lt;?php echo $CURRENT_USER['hospital'] ?&gt;</strong></em> part because if i change it to a value it works fine. </p>
<p>Regards</p>

<p>Andreas</p>
<blockquote>
<pre class="language-php"><code>SELECT CONCAT (fullname, " ", name)
  FROM `&lt;?php echo $TABLE_PREFIX ?&gt;accounts`
  WHERE hospital=&lt;?php echo $CURRENT_USER['hospital'] ?&gt;
  ORDER BY fullname</code></pre>
</blockquote>]]></description>
          <pubDate>Fri, 01 Mar 2019 09:09:39 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2243103#post2243103</guid>
        </item>
              </channel>
    </rss>
  