The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
[SQL] - adding the SUM in an array
So I am pulling data from my table like this:
PHP Code:
The issue is this table stores multiple entries per userid, thus only displaying the latest table entry as the results in templates. I want to add each entry together, that way when I use the $var[row] in my template it gives a TOTAL rather than the latest entry. Now I know I can do this with the following method: PHP Code:
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 |
#2
|
|||
|
|||
Quote:
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. Quote:
Code:
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; |
Благодарность от: | ||
Dr.CustUmz |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|