Complicated SQL...

[Charisma Bypass]

opi, oi, pi, pm, pn, pp, fp, pt, pq,
48,   42,   19,   blah,   blah,   49.99,   99.98,   0.00,   2
47,   42,   28,   test,   test,   18.99,   18.99,   0.00,   1

What I need to do is this:

Add the total value of pq and assign it to $total_units
Add the total value of pt and assign it to $total_price
Get the values of pi and output it comma separated to $product_ids
Get the values of pq that correspond with pi and output comma separated to $product_units
All of that based on oi

So, in the example above,
$total_units = 3
$total_price = 117.97
$product_ids = 19,28
$product_units = 2,1

Thank you in advance, I'm fuddled.

[JasonD]

SELECT SUM(pq) AS total_units,
SUM(pt) AS total_price,
GROUP_CONCAT(pi) AS product_ids,
GROUP_CONCAT(pq) AS product_units
FROM sometable
WHERE oi = 42

Or possibly GROUP BY oi instead of WHERE, depending if you want one or all.

[Charisma Bypass]

Thank you very much Jason.  Very much appreciated.