VTS Posted July 31, 2006 Share Posted July 31, 2006 Ok, I will try to explain this as best as I can. I have a table with data in it like this:sda_id sda_amt sda_date 1 23.45 2006-07-21 2 45.22 2006-07-21 1 23.90 2006-07-20 2 46.32 2006-07-20 1 29.09 2006-07-19 2 60.06 2006-07-19and this goes on for a complete week and there are about 40 different total ids. What I am trying to do with this take the totals for each id and get their sum for a week and then store this new week total in a different table. This other table will have id, week_amt and date for the headings in it. I don't really know where to start with this. If I did not post enough info just let me know and I will try to get a little more detailed. Thanks for any help in advance. Link to comment https://forums.phpfreaks.com/topic/16143-php-and-mysql-problemsneed-help-with-a-query-figured-it-out-nvm/ Share on other sites More sharing options...
king arthur Posted July 31, 2006 Share Posted July 31, 2006 Does the table only contain data for one week, which you want the totals for? Or is there data for more than one week, and you want the totals for each? Link to comment https://forums.phpfreaks.com/topic/16143-php-and-mysql-problemsneed-help-with-a-query-figured-it-out-nvm/#findComment-66648 Share on other sites More sharing options...
VTS Posted July 31, 2006 Author Share Posted July 31, 2006 The sda table contains data by day and it will have data for more than just one week. Data will get stored into it each day and I want to take this daily data and store it into another table by week so that I have a weekly total field stored. I want the weekly total for each id. Link to comment https://forums.phpfreaks.com/topic/16143-php-and-mysql-problemsneed-help-with-a-query-figured-it-out-nvm/#findComment-66653 Share on other sites More sharing options...
VTS Posted August 1, 2006 Author Share Posted August 1, 2006 NVM, I figured it out. Link to comment https://forums.phpfreaks.com/topic/16143-php-and-mysql-problemsneed-help-with-a-query-figured-it-out-nvm/#findComment-67102 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.