<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>Show the highest number</title>
        <link>https://interactivetools.com/forum/forum-posts.php?Show-the-highest-number-79914</link>
        <description></description>
        <pubDate>Sun, 14 Jun 2026 10:22:47 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;Show-the-highest-number-79914" rel="self" type="application/rss+xml" />

                <item>
          <title>Show the highest number</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2236020#post2236020</link>
          <description><![CDATA[<p>Happy to help!</p>]]></description>
          <pubDate>Wed, 11 Feb 2015 09:54:57 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2236020#post2236020</guid>
        </item>
                <item>
          <title>Show the highest number</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2236016#post2236016</link>
          <description><![CDATA[<p>Thank you for your help.</p>

<p>It works a treat.</p>]]></description>
          <pubDate>Wed, 11 Feb 2015 08:51:48 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2236016#post2236016</guid>
        </item>
                <item>
          <title>Show the highest number</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2236014#post2236014</link>
          <description><![CDATA[<p>Try something like this if you want just the top leader:  (You will need to substitute your variables for table and field names)</p>
<p><code>&lt;?php // load the top points records assuming you only want the top leader<br />  list($houseRecords, $houseMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'house', // or whatever the table name is<br />        'orderBy' =&gt; 'points+0 DESC' // bring highest points to top   <br />        'limit'       =&gt; '1',<br />    'allowSearch' =&gt; false,<br />  ));<br />  $topRecord = @$houseRecords[0]; // get first record only<br />?&gt;<br />&lt;div class="some-wrapper"&gt;<br />  The leaders are &lt;?php echo $topRecord['name'] ?&gt; with &lt;?php echo $topRecord['name'] ?&gt; points.<br />&lt;/div&gt;</code></p>
]]></description>
          <pubDate>Wed, 11 Feb 2015 06:38:53 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2236014#post2236014</guid>
        </item>
                <item>
          <title>Show the highest number</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2236007#post2236007</link>
          <description><![CDATA[<p>Thanks for the reply. I guess I should read more!</p>
<p>I have also been trying to put:</p>
<p>The leaders are "House name" with "points score" points.</p>
<p>Help with this would be appreciated thank you.</p>
<p>John</p>]]></description>
          <pubDate>Tue, 10 Feb 2015 11:21:59 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2236007#post2236007</guid>
        </item>
                <item>
          <title>Show the highest number</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2236005#post2236005</link>
          <description><![CDATA[<p>Hi John,</p>
<p>Assuming you have a "Points" field in CMS Builder for each House, you can have the Houses sorted by the highest to lowest by using the the Sort order in the CMS Builder admin or add it directly into the frontend template.</p>
<p>Sort in CMS Builder:<br />Go to Admin &gt; Section Editors &gt; Houses. <br />Click on the Sorting tab and add <strong>points+0 DESC</strong><br />This will sort the Houses by Points, highest to lowest in both the CMS Builder admin and the published frontend page.<br /><br /></p>
<p>You can also do a custom sort just on the publish page if you don't want the CMS Builder admin sorted in the same way. To do this, add the orderBy code to your page:</p>
<p>'orderBy' =&gt; '<strong>points+0 DESC</strong>', <br /><br />More details here:<br /><a href="http://www.interactivetools.com/docs/cmsbuilder/viewer_options.html" rel="nofollow">http://www.interactivetools.com/docs/cmsbuilder/viewer_options.html</a></p>
<p>Hope this helps!</p>]]></description>
          <pubDate>Tue, 10 Feb 2015 10:44:26 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2236005#post2236005</guid>
        </item>
                <item>
          <title>Show the highest number</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2236004#post2236004</link>
          <description><![CDATA[<p>I am trying to help a school display the House with the most house points at the end of each week.</p>
<p>There are 5 houses. How can I show the house with the highest points please? </p>
<p>Any help would be appreciated.</p>

<p>Many thanks</p>

<p>John</p>]]></description>
          <pubDate>Tue, 10 Feb 2015 05:53:51 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2236004#post2236004</guid>
        </item>
              </channel>
    </rss>
  