<div>
Strange, the repeat region only displays the count of the first record. &nbsp;User 1 has 3 so it repeats 3
</div>


Strange, the repeat region only displays the count of the first record.  User 1 has 3 so it repeats 3

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have two tables<br />
<br />
tblUsers<br />
UserID &nbsp;UserName<br />
<br />
tblLeads<br />
LeadID &nbsp;UserID &nbsp;LeadName<br />
<br />
and I need to display how many Leads each User has. &nbsp;The data is being displayed in a Users table with repeat region. &nbsp; I should probably make a separate RecordSet for this calculation.<br />

</div>
</div>


Hi,
I have two tables

tblUsers
UserID  UserName

tblLeads
LeadID  UserID  LeadName

and I need to display how many Leads each User has.  The data is being displayed in a Users table with repeat region.   I should probably make a separate RecordSet for this calculation.


Count how many leads each user has

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Websites use graphics to enhance information, assist navigation, and generally improve the user’s experience. To create those graphics, developers use any number of programs, like the Adobe Creative Suite (Photoshop and Flash have their own topics), the CorelDraw suite, Xara, Gimp, ACDSee, Serif, ULead and others.