I want to pull a value from the "previous" december but I don't know how.

I know how to pull the value from January of a month but that's it.

PHP Code:

$resp = '';
$year= '';

$i=0;

while ($row = mysql_fetch_array($rs, MYSQL_ASSOC)) 
    {
    $mnth=$row["month_no"];

    $prev_month=$row["prior_month"];

[B]    $first_month=$row["jan_month"];[/B]

    $since_inception=($row["gross_nav"])-($row["fund_begin_price"])/($row["fund_begin_price"]);

    $performance=((($row["gross_nav"])-1)*100);

    if($prev_month == 0)
    {
    $net_nav=0;
    }
    else
    {
    $net_nav=((($row["gross_nav"]-$row["prior_month"])/$row["prior_month"])*100);
    }

    if($first_month == 0)
    {
    $return=0;
    }
    else
    {
        if($mnth == 1)
        {
        $return=((($row["gross_nav"]-$row["prior_month"])/$row["prior_month"])*100);
        }
        else
        {
        $return=[B]((($row["gross_nav"]-$row["jan_month"])/$row["jan_month"])*100);[/B]
        }
    }
            
    

    $resp .= '<nav date="'.$row["cost_date"].'" gross_nav="'.$row["gross_nav"].'" dividend="'.$row["dividend_units"].'" net_nav="'.number_format($net_nav, 2, '.', ',').'%" return="'.number_format($return, 2, '.', ',').'%" since_inception="'.round($performance,4).'%"/>';    
    
        } 


Focus on the bold text. Where I used January of the month. What I want is to substitute it with December of the previous year. Can you help me please?

Why are you messing about with PHP when the database server can do that the FAR more efficiently?

Originally Posted by chrishirst

Why are you messing about with PHP when the database server can do that the FAR more efficiently?

Hello Chrishirst. Thank you for replying.

The database is mySQL but I don't know how to adjust the database I use mySQL Query Browser.

Basically what I need is to call the previous month (which is december) when month == 1 (January) and save that month's value and then use this value with my calculations.


Something like

if ($mnth == 1) <-- January
{
$dec_month=$row["prior_month"];
}

then I use $dec_month on my calculations.. but my syntax doesn't work :/

okay I solved the problem, it was easy I just am not familiar with php syntax (even though it's pretty close to C++).

if f ($mnth == 1)
{
$december=$row["prior_month"];
}

So, now we have the value of the previous december and using the variable $december in my calculations and finally can calculate the Year to Date fund performance.