# Count MySQL records from 3 tables and display on page

**URL:** <https://forum.kirupa.com/t/count-mysql-records-from-3-tables-and-display-on-page/254319>\
**Category:** programming\
**Created:** [March 10, 2008, 10:01pm UTC](https://forum.kirupa.com/t/count-mysql-records-from-3-tables-and-display-on-page/254319 "2008-03-10T22:01:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![im1](https://avatars.discourse-cdn.com/v4/letter/i/848f3c/32.png) [@im1](https://forum.kirupa.com/u/im1)\
**Post date:** [March 10, 2008, 10:01pm UTC](https://forum.kirupa.com/t/count-mysql-records-from-3-tables-and-display-on-page/254319/1 "2008-03-10T22:01:05Z")

</div>

I have a search engine, all my search terms are recorded into the database and split into three different tables:

-Music Search  
-Video Search  
-Picture Search

What I wanna do is somehow count all the records in all the tables and then output the number on the site (like a TOTAL SEARCHES: [number])