Counts records by $field (can be all fields if this value is (*) ) from $table in some $conditions (default no conditions) written in SQL syntax.
dbcount
Docs
PHPFusion Development
Core Functions verify_image uncompressIPv6 trimlink theme_exists stripslash stripinput stripget showdate set_admin_pass redirect profile_link preg_check phpentities parseubb parsesmileys parsebytesize make_captcha makepagenav makefileopts makefilelist isnum highlight_words hide_email groupaccess getuserlevel getusergroups getgroupname formatcode displaysmileys descript dbrows dbresult dbquery dbcount dbconnect dbarraynum dbarray cleanurl check_captcha check_admin_pass checkrights checkgroup censorwords cache_smileys cache_groups cache_bbcode addslashTheme FunctionsOther FunctionsMail FunctionsComments and RatingsPhoto Gallery FunctionsInfusions FunctionsOutput HandlingForum FunctionsBBCodesCustom includesJavascript Functionsdbcount
Quote
dbcount ( string $field, string $table, [ string $conditions] )
Parameters
field
The fields you want to count in the database
table
The table you want to count from
conditions
The conditions you want to the results to match
Return Values
This function will return the number of rows in the $table matching the $conditions if any.
This function will return false if there are no rows or on failure.
Example
Code
<?php
echo dbcount("(field1)", "table1", "field1='this'");
?>
Changelog
7.01.00 - Added query count
7.00.00 - Removed db_prefix from the $table in order to use the multisite feature in PHPFusion 8
Note
This function will return false if the query fails or if there are no rows to count.