[SQL] - adding the SUM in an array

[shka]

Originally Posted by Dr.CustUmz

So I am pulling data from my table like this:

PHP Code:

$data = $db->query_read ("SELECT * FROM " . TABLE_PREFIX . "someTable WHERE userid=" . intval ($vbulletin->userinfo['userid']));
while ($var = $db->fetch_array ($data)) {
  $var = $data;
} 


First: Don't use "select *". You should query only columns you need. You (and readers of your code) have more control over data flow and will thank it later.
SELECT userid, row, row2, row3, row4 FROM...

Second: I don't have vB3, but isn't there an fetch_all? You don't need to read the data line by line.

Originally Posted by Dr.CustUmz

Anyone want to help me out with this.

Example of my table:

userid__row___row2__row3___row4
1______1_____3____3.00_____4
1______1_____2____2.00_____3
2______1_____5____5.00_____6
1______1_____3____3.00_____4
2______1_____3____3.00_____4

So my goal $vars would return the following results in templates (for userid 1)

$var[row] = 3
$var[row2] = 8
$var[row3] = 8.00
$var[row4] = 11

If I understood correct GROUP BY combined with SUM should be your friend

SELECT 
    userid,
    SUM(row) AS row_sum,
    SUM(row2) AS row2_sum,
    SUM(row3) AS row3_sum,
    SUM(row4) AS row4_sum
FROM 
    " . TABLE_PREFIX . "someTable 
GROUP BY
    userid;