<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>Listing by letters of the alphabet</title>
        <link>https://interactivetools.com/forum/forum-posts.php?Listing-by-letters-of-the-alphabet-68903</link>
        <description></description>
        <pubDate>Wed, 18 Nov 2026 20:44:57 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;Listing-by-letters-of-the-alphabet-68903" rel="self" type="application/rss+xml" />

                <item>
          <title>Re: [richo] Listing by letters of the alphabet</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2191723#post2191723</link>
          <description><![CDATA[John, welcome to the CMS Builder forum! :)<br /><br />That's a bit more of an advanced request, but you can do it with a MySQL WHERE statement like this: <span style="color:red">title LIKE &quot;a%&quot;</span><br /><br />So you can either add that in the code generator or to the code itself like this:<br /><br /><code>list($newsRecords, $newsDetails) = getRecords(array(<br />  'tableName'   =&gt; 'news',<br />  'perPage'     =&gt; 3,<br />  <span style="color:red">'where'       =&gt; 'title LIKE &quot;a%&quot;',</span><br />));</code><br /><br />Hope that helps!  Let me know if you need more details.<br />]]></description>
          <pubDate>Mon, 26 May 2008 11:13:25 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2191723#post2191723</guid>
        </item>
                <item>
          <title>Listing by letters of the alphabet</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2191720#post2191720</link>
          <description><![CDATA[I am a new user of CMS Builder and just getting used to it. It's an excellent product. <br /><br />I have used the php code to list my data but how can I display all records in the title field that begin with the letter A for example. I want to create a different php page for each letter of the alphabet. <br /><br />Hope you can help. Many thanks. <br /><br />John<br />]]></description>
          <pubDate>Mon, 26 May 2008 05:45:02 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2191720#post2191720</guid>
        </item>
              </channel>
    </rss>
  