MYSQL Record Count

5 posts by 2 authors in: Forums > CMS Builder
Last Post: July 15, 2014   (RSS)

By shawn - July 14, 2014

Hi guys,

I have created a checkbox called "Popular" and at the moment its returning the count of all listings checked. However, how do I get a count of listings checked as popular belonging to my multi-list values? i.e.  'where' => "city = 'CT'",

list($listingRecords, $listingMetaData) = getRecords(array(
    'tableName'   => 'listing',
    'where' => "city = 'CT'",
  ));

This is giving me the record count of all listings checked "Popular".

<? echo mysql_select_count_from('listing','popular');?>

I want to know how many listings are checked popular for the City = "CT"...

Any assistance greatly appreciated.

By claire - July 15, 2014

Hi Shawn

What does your 'popular' field look like?

--------------------

Claire Ryan
interactivetools.com

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

By shawn - July 15, 2014

Hello Claire

Thank you for the reply. Not sure what you mean exactly? It's just a checkbox field type with fieldname "popular". The table name is 'tableName'   => 'listing',

Popular (value): <?php echo $record['popular'] ?>
Popular (text):  <?php echo $record['popular:text'] ?>


I have a muli-list called "city".

 City (value): <?php echo $record['city'] ?>
 City (label): <?php echo $record['city:label'] ?>

So I basically I'm filtering my listings: 'where' => "city = 'CT'", and would like to know which over those listings in "CT"are checked as "Popular".

At the moment I can return a count for all listings checked as popular like this, but only want those 'where' => "city = 'CT'"

<? echo mysql_select_count_from('listing','popular');?>

By claire - July 15, 2014

Hi Shawn

Just wanted to be sure I understand what your setup is like. Try this function instead:

<?php echo mysql_count('listing', 'city = "CT" AND popular = 1'); ?>

This will give you a little more leeway in how you select the records.

--------------------

Claire Ryan
interactivetools.com

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