jaymc Posted September 8, 2007 Share Posted September 8, 2007 I have a query, it has a limit of 25 however there are 100's of records Im having it display 25 results per page hence the limit However, On the page I want to display 1: How many rows exist in the database regardless of the limit 2: The sum of a certain field for the entire database where the query matches I use 'SQL_CALC_FOUND_ROWS' for the first 1 and that works fine, however, how can I pull out the actually SUM of a field in the database with a LIMIT I want to avoud running a totally seperate query to find that info Cheers Link to comment https://forums.phpfreaks.com/topic/68473-sum/ Share on other sites More sharing options...
Barand Posted September 8, 2007 Share Posted September 8, 2007 Most efficient way for 1 is SELECT COUNT(*) FROM tablename. 2 needs clarification The sum of a certain field for the entire database or The sum of a certain field where the query matches Link to comment https://forums.phpfreaks.com/topic/68473-sum/#findComment-344327 Share on other sites More sharing options...
fenway Posted September 8, 2007 Share Posted September 8, 2007 Most efficient way for 1 is SELECT COUNT(*) FROM tablename. Not in InnoDB..... Link to comment https://forums.phpfreaks.com/topic/68473-sum/#findComment-344465 Share on other sites More sharing options...
Barand Posted September 8, 2007 Share Posted September 8, 2007 In which case one should use ... ? Link to comment https://forums.phpfreaks.com/topic/68473-sum/#findComment-344467 Share on other sites More sharing options...
jaymc Posted September 9, 2007 Author Share Posted September 9, 2007 Most efficient way for 1 is SELECT COUNT(*) FROM tablename. 2 needs clarification The sum of a certain field for the entire database or The sum of a certain field where the query matches The sum of a certain field for the entire database Link to comment https://forums.phpfreaks.com/topic/68473-sum/#findComment-344516 Share on other sites More sharing options...
fenway Posted September 9, 2007 Share Posted September 9, 2007 In which case one should use ... ? ...summary tables. Link to comment https://forums.phpfreaks.com/topic/68473-sum/#findComment-344562 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.