Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 06 May 2020, 05:55
Dr.CustUmz's Avatar
Dr.CustUmz Dr.CustUmz is offline
 
Join Date: Aug 2013
Real name: Ryan
Question [SQL] - adding the SUM in an array

So I am pulling data from my table like this:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

So: $var[row] is usable in my templates (and that is all working fine)

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Then use $var[total] but I have to do this for almost every row on the table and feel (if possible) it would be better to do this as an array.

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
__________________
This needs to be updated
But I don't know what to put
Check Out Dirt RIF CustUmz
Reply With Quote
  #2  
Old 06 May 2020, 07:34
shka shka is offline
 
Join Date: Mar 2016
Originally Posted by Dr.CustUmz View Post
So I am pulling data from my table like this:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
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 View Post
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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Miscellaneous Hacks vBHELP - Sum Your Upload / Files Size Max Kwiatkowski vBulletin 3.7 Add-ons 4 13 Sep 2008 13:15


Tags
array, database, mysql, product, query


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 19:46.

Layout Options | Width: Wide Color: