mysql_count
3 posts by 2 authors in: Forums > CMS Builder
Last Post: July 5, 2018 (RSS)
By petrogus - July 5, 2018
Hi everyone,
I would like to use the mysql_count in order to appear different section depend of the number of the records per type,
I have created table named "products" and i use list "type" in order to filtering them.
if the sum of the records which filtered by type is 1 or more than 1.
i use this one
<?php $modelCount = mysql_count('products', 'type'); ?>
<?php if ($modelCount == 1) { ?>
section A
<?php } elseif($modelCount > 1) { ?>
section B
<?php } ?>
example
model AA have type A --> view in section 1
and
model B and type B
model 2B and type B --> View in section 2
Could you help me please !
petrogus
By leo - July 5, 2018 - edited: July 5, 2018
Hi,
Here is an example of mysql_count usage:
mysql_count('products', 'type = "' . $type . '"');
Let me know if you have any questions!
Thanks,
interactivetools.com