Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Modifications and Requests - 8
  5. Database Count

Database Count

Asked Modified Viewed 866 times
Back to Forum Index Previous Topic Next Topic
Print
C
Catzenjaeger
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions
asked
Senior Member

Hello,

i want count forums with 2 criteria:

1) forum_cat > '0'
2) forum_name LIKE '[%' (my forums look like so: [BA/125] British Airways)

i have try it but get errors. Im not a hero in SQL and want to ask for help :)

Code Download source
$result2 = dbquery("SELECT COUNT *  FROM ".DB_FORUMS." WHERE forum_cat > '0' AND forum_name LIKE '[%'");

$threads_rows = dbcount("(thread_id)", DB_THREADS,"");

echo "<td class='tbl1' align='center' colspan='4'>".$locale['abz11']."<b>$result2</b> ".$locale['abz12']." <b>$threads_rows</b>".$locale['abz13']."</td>\n";
0 replies
There are no post found.

Category Forum

Modifications and Requests - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 0 posts
  • Votes 0 votes
  • Topic users 1 member

1 participant

C
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet