<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>Re: Re: [Jason] showing record count</title>
        <link>https://interactivetools.com/forum/forum-posts.php?Re-Re-Jason-showing-record-count-82391</link>
        <description></description>
        <pubDate>Sun, 19 Jul 2026 14:27:29 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;Re-Re-Jason-showing-record-count-82391" rel="self" type="application/rss+xml" />

                <item>
          <title>Re: Re: [Jason] showing record count</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2245430#post2245430</link>
          <description><![CDATA[<p>Hi JH,</p>
<p>In this case you could use the `mysql_count` function ( mysql_count($tableName, $whereEtc) ). Used in the below format:</p>
<pre class="language-php"><code>$jeffCount = mysql_count('project_management', "`current_owner` = 'jeff'");</code></pre>
<p>This would return a count for every project associated with Jeff's name. If you needed to filter by other parameters (like project_status = 'active' for example) you could add that to the second part, setting it up like a where clause concatenating with AND/OR etc.</p>
<p>Please let me know if this helps you at all for your situation.</p>]]></description>
          <pubDate>Mon, 01 Mar 2021 10:04:05 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2245430#post2245430</guid>
        </item>
                <item>
          <title>Re: Re: [Jason] showing record count</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2245420#post2245420</link>
          <description><![CDATA[<p>In response to: <a href="https://www.interactivetools.com/forum/forum-posts.php?postNum=2214836#post2214836" rel="nofollow">https://www.interactivetools.com/forum/forum-posts.php?postNum=2214836#post2214836</a></p>
<p>In response to that post - I cannot seem to wrap my head around getting this to work in my case.</p>
<p>I want to be able to grab a count of the number of records that are assigned values.</p>
<p>For instance, my table is:  project_management  (that's the top level cms section).</p>
<p>Inside that - I have a field of "current_owner".</p>
<p>There's a list of possible selections a person can assign a project to - names of my team.</p>
<p>I just wanted to drop some numbers so, at a glance, I can see how many projects are in each person's cue.</p>
<p>(echo number of records where "jeff" is the value in field "current_owner" for instance.)</p>
<p>And then I can pull for each team member after that.  </p>
<p>I can't seem to wrap my head around this solution.<br /><br />Thanks, in advance, for any help!</p>
<p>--JH</p>]]></description>
          <pubDate>Thu, 25 Feb 2021 16:48:05 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2245420#post2245420</guid>
        </item>
              </channel>
    </rss>
  