Grouping using while loop

[Syazri]

This is example of my record:

 

 

1. year quanitity name
2. 2012 10 john
3. 2012 20 mark
4. 2013 30 david
5. 2013 40 alex
6. 2014 50 stacy

while (!$report->EOF){
if(is_null($year) || $year <> $report->fields['year']) {
$year = $report->fields['year'];
?>
<tr><td align="center" colspan="2" >Year : </td><td><?=$year ?></td></tr>
<?
}
?> 
<tr><td align="center" colspan="2" >Quantity : </td><td><?=$report->fields['quanitity'] ?></td></tr>
<?
$report->MoveNext(); 
}

How to do so the result goes like this

1) group by years

2) total quantity for each year

year : 2012
name : john quantity : 10
name : mark quantity : 20

Total : 30

 

year : 2013
name : david quantity : 30
name : alex quantity : 40
Total : 70

 

 

 

[Barand]

pseudocode

prevYear = 0
total = 0
while fetch next row {
    if year <> prevYear {
        if prevyear <> 0 {
            output total
        }
        output year
        prevYear = year
    }
    output row data
    total += quantity
}

[Barand]

correction to above pseudocode

prevYear = 0
total = 0
while fetch next row {
    if year <> prevYear {
        if prevyear <> 0 {
            output total
            total = 0             // added
        }
        output year
        prevYear = year
    }
    output row data
    total += quantity
}
output total              // added

[Syazri]

Thanks @guru.. but is this php?

[Syazri]

Im sorry.. i dont know how to translate into php language

[Jessica]

https://www.google.com/search?q=define+pseudo+code

 

Try.

[Syazri]

Thanks for the link.. is there any other example that will answer my question? its been 4 days im searching for the answer..

[Jessica]

I can write it for you, but it'll cost you. *shrug*

[Yohanne]

if there is a selection option for year to show up the following you want.

$query_list("SELECT year, quantity, name from BDNAME WHERE year = '$selected_year'");
$query_result = mysql_query($query_list);

thin apply from guru suggestion and others.