Summing a field from all tables in a database

[ArizonaJohn]

Hello,

 

I have a MySQL database called "bookfeather." It contains 56 tables. Each table has the following structure:

 

id site votes_up votes_down

 

The value for "site" is a book title. The value for "votes_up" is an integer. Sometimes a unique value for "site" appears in more than one table.

 

For each unique value "site" in the entire database, I would like to sum "votes_up" from all 56 tables. Then I would like to print the top 25 values for "site" ranked by total "votes_up".

 

How can I do this in PHP?

 

Thanks in advance,

 

John

[ldougherty]

You'll want to use the SUM function.

 

http://www.tizag.com/mysqlTutorial/mysqlsum.php

 

To return specific results in your query just use a WHERE clause to meet your needs along with DISTINCT to make sure you only get unique values.

 

http://dev.mysql.com/doc/refman/5.0/en/distinct-optimization.html

[Mark Baker]

I have a MySQL database called "bookfeather." It contains 56 tables. Each table has the following structure:

Why do you have a database containing 56 identically structured tables?