Hello everyone, In a PHP / Postgresql application I have to make a lot of lists like this: THE DATA STRUCTURE employee_number, employee_name, department THE OUTPUT ------------------------------------ employee_number employee_name department X 1 Johnson 22 Jackson subtotal: 2 employees department Y 222 Smith 3 Doe 44 Jameson subtotal: 3 employees grand total: 5 employees ------------------------------------ I see 2 ways to solve this: - use SELECT for the detail lines and SELECT COUNT (*) for the (sub) totals - SELECT the whole lot and let PHP do the grouping and counting The second solution seems old fashioned to me and the first has a catch: all queries have to be made within a single transaction. I have the feeling that this is a very common question, how do you people handle it? I looked at a lot of script sites, but no luck. Thanks for any ideas / feedback!
