ArizonaJohn Posted August 5, 2009 Share Posted August 5, 2009 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 Link to comment https://forums.phpfreaks.com/topic/169015-summing-a-field-from-all-tables-in-a-database/ Share on other sites More sharing options...
ldougherty Posted August 5, 2009 Share Posted August 5, 2009 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 Link to comment https://forums.phpfreaks.com/topic/169015-summing-a-field-from-all-tables-in-a-database/#findComment-891753 Share on other sites More sharing options...
Mark Baker Posted August 6, 2009 Share Posted August 6, 2009 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? Link to comment https://forums.phpfreaks.com/topic/169015-summing-a-field-from-all-tables-in-a-database/#findComment-891955 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.