Syazri
-
Posts
4 -
Joined
-
Last visited
Posts posted by Syazri
-
-
Im sorry.. i dont know how to translate into php language
-
Thanks @guru.. but is this php?
-
This is example of my record:
- year quanitity name
- 2012 10 john
- 2012 20 mark
- 2013 30 david
- 2013 40 alex
- 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 : 20Total : 30
year : 2013
name : david quantity : 30
name : alex quantity : 40
Total : 70
Grouping using while loop
in PHP Coding Help
Posted
Thanks for the link.. is there any other example that will answer my question? its been 4 days im searching for the answer..