PHP - Monthly Sum

Okay guys, I figured out how to calculate monthly subscriptions into days, but I am stuck on calculating multiple monthly subscriptions.. for example

Heres my mysql table:


How would I calculate this:
Subscription Start: February 21, 2011, 12:00 am
Subscription End: April 22, 2011, 12:00 am
Subscription Left: 60 days

My trouble is that when the user buys another month, it calculates the end time based on the new "Subscription Start Date". Or vice versa.

Any ideas guys?
Thanks.

Hi,

i have created a mysql table for account info which stores basic expenses and income
I have also account.php page that shows the all transactions 10 transaction (row) per page.
 there is no problem with that but I like it to show the transactions(entries) per month base. I mean when i open this page i want it to show this month's entries. and when i click previous button i like to see last month's entries.

any help will be appreciated.

thanks in advance.

regards.

Hi all,

I'm trying to make a webpage that allows the user to enter new sales figures for a certain product in a chosen month of a chosen year. I thought my code was correct but it doesn't really do anything. It just displays the table but it's not updated.

Can anybody spot an error?

Code: [Select]
   $describeQuery = "SELECT p.ID, p.NAME, dt.[Year], dt.[Month], dt.SalesVolume from Products p
join
(select ProductCode, sum(SalesVolume) as SalesVolume, [Month], [Year] from MonthlySales
 where [Year] = '$desiredYear' AND [Month] = '$desiredMonth'
 group by ProductCode, [Year], [Month])dt
on dt.ProductCode = p.ID";

$editQuery = "UPDATE MonthlySales SET SalesVolume = '$newSales'  WHERE Month ='$desiredMonth' AND Name = '$desiredProduct' AND Year = '$desiredYear'";

$results = sqlsrv_query($conn, $describeQuery);
$resultsx = sqlsrv_query($conn, $editQuery);

echo '<table border="1" BORDERCOLOR=Black>';
echo '<tr><th bgcolor = "LightBlue">Name</th><th bgcolor = "LightBlue" >ID</th> <th bgcolor = "LightBlue" >Sales</th><th bgcolor = "LightBlue" >Month</th> <th bgcolor = "LightBlue" >Year</th> </tr>';


while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC))
  {   
  echo '<tr>';
echo '<td >' .$row['NAME'].'</td>';             
echo '<td>' .$row['ID'].'</td>';
echo '<td>' .$row['SalesVolume'].'</td>';
echo '<td>' .$row['Month'].'</td>';
echo '<td>' .$row['Year'].'</td>';
echo '</tr>';
}

echo '</table>';

while($row = sqlsrv_fetch_array($resultsx, SQLSRV_FETCH_ASSOC))
  {
  }

sqlsrv_close($conn);

I got an idea with my homepage in progress. It's a blog and I want to sort my post in a navigation bar. Is it possible to do a script with $date function to create a new file the 1th of every month. Then use file_get_content on the current month.   To clarify in this stage I haven't started connecting my database.
Edited by DexterTheCat, 05 June 2014 - 11:16 AM.

I would like some tips on how to create a monthly archive for my weblog.
I am not using MySQL or any databases. Everything is saved on file.
 any tips or tutorials?

Thanks