edoggie

I will try this and get back to you. Thnx.

I think what you are looking for is using ob_start(), ob_end_flush(), and ob_get_contents() to basically store your results into a cache and then use ob_get_contents() to store the resulting data into a variable which could be saved out to a database. Hopefully this is a good start.

I need to get the number of years past between two dates, with accuracy down to the 12AM hour on the rollover day. So basically on the exact hour a new year begins I am returning 1 year, 2 years, etc. This is the code I have thus far function datediff_new($interval, $datefrom, $dateto, $using_timestamps = false) { if (!$using_timestamps) { $datefrom = strtotime($datefrom, 0); $dateto = strtotime($dateto, 0); } if ($interval == 'yyyy') { $returned_days = $this->count_days($datefrom,$dateto); //echo "Number of returned days {$returned_days}<br />"; //echo "Number of returned years {$return_years}"; $leap_days = $this->leap_years(date('Y',$datefrom), date('Y',$dateto)); if (date('Y',$dateto) < 12) { $leap_days-1; echo "Reduce by 1 year"; } $return_years = floor($returned_days/(365+$leap_days)); echo 'Number of days: '; echo 365+$leap_days; echo '<br />Return Years: ' . $return_years . '<br />'; return $return_years; } else { die('undefined error vesting_lib - line 1614'); } } // Will return the number of days between the two dates passed in //send in dates as unix timestamp function count_days( $a, $b ) { // First we need to break these dates into their constituent parts: $gd_a = getdate( $a ); $gd_b = getdate( $b ); // Now recreate these timestamps, based upon noon on each day // The specific time doesn't matter but it must be the same each day $a_new = mktime( 0, 01, 00, $gd_a['mon'], $gd_a['mday'], $gd_a['year'] ); $b_new = mktime( 0, 01, 00, $gd_b['mon'], $gd_b['mday'], $gd_b['year'] ); // Subtract these two numbers and divide by the number of seconds in a // day. Round the result since crossing over a daylight savings time // barrier will cause this time to be off by an hour or two. return round( floor($b_new - $a_new) / 86400 ); } function leap_years($start, $end) { $extra_days = 0; while($start <= $end) { $leap = (date('L', strtotime("{$start}-01-01"))) ? true : false; //echo $leap, '<br /> '; if ($leap) { $extra_days++; } $start++; } return $extra_days; } And this is an example usage of the above code: $return_years = $this->datediff_new('yyyy', $from_date, $to_date, false); Originally I was using an approximation, the count days function was returning the number of days between two dates, then I was dividing that by "365.24" to get the number of years. Unfortunately this doesn't really work do down to the hour because depending on how many leap years are given in a specific period this number may be more or less. So I added a Leap year function to try to return the number of leap years in the given period. But this doesn't seem to have improved the accuracy.

Thats a nice example, but I'm afraid it wouldn't work within my application. Each participant might have a different "Enrollment Date" for the program, so they would have a different Start and End date. The grouping are of arbitrary length, for each year within the plan. So I would have too many tables I would have to come up with and too many additional tables to join. Anyone have any other suggestions or improvements to Barand's design so that I could accomplish the task without so many additional tables being generated?

I need to create a query such as the following: SELECT SUBSTRING(contributions.apply_date,1,4) as year_made, SUM(amount) AS year_total FROM contributions WHERE contributions.contributed_for = {$user_id} AND apply_date >= '{$start_date}' AND apply_date <= '{$end_date}' GROUP BY year_made ORDER BY year_made DESC but instead of Grouping the data by the Substring year_made I want to group the data from an arbitrary date range, like 3-01-2007 to 2-31-2008 and then by 3-01-2008 to 2-31-2009 etc. So each GROUP BY result would have the SUM(amount) AS year_total be equal to the total contributions_for for the given range? I don't know exactly how I would do this, other then creating a PHP loop and create each Summary via seperate MySQL call. Is there anyone that can build this functionality entirely in MySQL. Seems to be like it should be possible somehow?

Thanks "Crayon Violent" I will try this and get back to you. I was trying to sort the order values for the months, since they seem to be coming out of order, even though the SQL query that made them has a orderby month in them, I think the merging of the data seems to mess up the order or something. The Contributions table looks like the following. cooldude832 this is a Retirement Fund project, PP stands for Participant Contribution. CC stands for Company Contribution. PP is Participant production. What's your modular CMS system like?

Ok I am having allot of trouble building what I need from this array. Can someone explain how to build a table in attachment 2 from the array in attachment 1. Example array could be any number of Years and up to 12 months per Year. I got up to echoing the month, but when I try to asort the given sub-group for the current month, everything goes crazy and I only get 4 sets of numbers with no correlation to the original values. print_r($data); $row1 = ''; $row2 = ''; $row3 = ''; $row4 = ''; $num_col = count($data) + 1; $num_array = count($data); for($y = 0; $y <= $num_array-1; $y++) { $month = array(); if (is_array($data)) { $current_year = key($data); //echo "<br>Year: " . $current_year; $year_contributions = current($data); //THIS ASORT SEEMS TO MESS EVERYTHING UP // How ever the print_r statement looks fine, so confused. //asort($year_contributions); // print_r($year_contributions); $num_of_months = count($year_contributions)-1; $row1 .= "<td colspan=\"{$num_of_months}\">{$current_year}</td>"; //foreach ($year_contributions AS $month=>) //echo (is_array($year_contributions)) ? "true" : "false"; //$row2 .= "<td>"; for($m = 0; $m <= $num_of_months-1; $m++) { $month_name = key($year_contributions); if ($month_name != 'pp') { $row2 .= "<td>{$month_name}</td>"; } next($year_contributions); } next($data); } echo "<table border=\"1\"><tr>"; echo $row1; echo "</tr><tr>"; echo $row2; echo "</tr></table>";