This function will give you the total number of rows in a given database query. This is often used to check for rows in a result before displaying content.
dbrows
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 Functionsdbrows
Quote
dbrows ( resource $query )
Parameters
query
The query resource that is being evaluated. This result comes from a call to dbquery().
Return Values
The number of rows in a result set on success, or FALSE on failure.
Example
Code
<?php
$result = dbquery("SELECT * FROM table1", $link);
$num_rows = dbrows($result);
echo "$num_rows Rowsn";
?>Notes
This function alone will not output anything.