showing record count

8 posts by 4 authors in: Forums > CMS Builder
Last Post: January 20, 2012   (RSS)

By (Deleted User) - February 9, 2011

Hi Guys

Is it possible to display a record count on the front-end of my site? i.e.

I want to display how many article or events are added, i.e. "showing 1-6 of 10".

Just so users know how many articles or events are on the site.

regards
Shawn

Re: [smesa] showing record count

Hi Shawn,

Here's a short recipe from my CMSB Cookbook http://www.thecmsbcookbook.com that should get you started.

WANT TO SHOW A RECORD COUNT ON YOUR WEB PAGE

You can use this to see the total number of records displayed:

<?php echo $your_table_nameMetaData['totalRecords']; ?>

There are a few other variables that can be used besides “totalRecords”. You can list them all with this code:

<xmp><?php print_r($your_table_nameMetaData); ?></xmp>

Hope that works for you,

Jerry Kornbluth
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

Re: [gkornbluth] showing record count

By (Deleted User) - February 9, 2011

Works like a charm Jerry. You're a legend!

Thanks very much!

Re: [smesa] showing record count

is there a way to show record count for records that are tagged a certain category.

for example, Im building a small blog and have categories listed down the side (tags). I have a tags section in the CMs where i create tag categories.

In my blog postings, there is a field where I select what tag/categories the post falls under.

Re: [Jason] showing record count

hmm getting error:
Notice: Undefined variable: tags in /hermes/bosweb26c/b2559/ipw.s2smedia/public_html/test/Shoutfeed/index.php on line 237 ( Notice: Undefined variable: tags in /hermes/bosweb26c/b2559/ipw.s2smedia/public_html/test/Shoutfeed/index.php on line 237 0)


here is my code:

<?php foreach ($newsRecords as $record): ?>
<div style="margin:8px 0px 4px 0px; font-weight:normal"><a href = "<?php echo $tags['_link'];?>">
<?php echo $tags['title'];?> (<?php echo mysql_count('news', "tag = '".$tags['num']."'");?>)
</a> </div>
<?php endforeach ?>


Here is my set up:

category field in my blog is named: "tag"
name of my blog is "news"

not sure what you mean by the option value.

Re: [s2smedia] showing record count

By Jason - January 20, 2012

Hi,

I think the error your getting is because you are using the variable $tags instead of $record.

In your news section, what type of field is "tag"? How is it set up?

Let me know,
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] showing record count

GOT IT.. Works like a charm!! thx