Database Discussion Boards

I've some data, there are

VB

RealData Balance 	 Sort by Desc
A  684 	 345 		 A  684 
B  60 	 -   		 E  308 
C  -   	 -   		 J  302 
D  -   	 -   		 I  273 
E  308 	 - 		 O  178 
F  -   	 -   		 H  140 
G  11 	 -   		 B  60 
H  140 	 - 		 N  27 
I  273 	 - 		 Q  22 
J  302 	 -   		 R  20 
K  -   	 -   		 P  14 
L  -   	 -   		 G  11 
M  -   	 -   		 C  -   
N  27 	 -   		 D  -   
O  178 	 38 		 F  -   
P  14 	 -   		 K  -   
Q  22 	 -   		 L  -   
R  20 	 4   		 M  -   

Description
Proc = Process
Res = Result
Sort by Desc

Get 8 row data 														
Proc 1  Res 1 	Proc 2  Res 2 	Proc 3 	 Res 3 	 Proc 4  Res 4 	 Finish for 8 row data
A  684  657 	A  657  635 	A  635 	 621 	 A  621  610 	 A  610  	
E  308  281 	E  281  259 	E  259 	 245 	 E  245  234 	 E  234 	
J  302  275 	J  275  253 	J  253 	 239 	 J  239  228 	 J  228 	
I  273  246 	I  246  224 	I  224 	 210 	 I  210  199 	 I  199 	
O  178  151 	O  151  129 	O  129 	 115 	 O  115  104 	 O  104 	
H  140  113 	H  113  91 	H  91 	 77 	 H  77 	 66 	 H  66 	
B  60 	 33 	B  33 	11 	R  20 	 6 	 B  11 	 -   	 R  6 	
N  27 	 -   	Q  22 	-   	P  14 	 -   	 G  11 	 -   	 B  -   	
Q  22 	 22 	R  20 	20 	B  11 	 11 	 R  6 	 6 	 G  -   	
R  20 	 20 	P  14 	14 	G  11 	 11 	 P  -    -   	 P  -   	
P  14 	 14 	G  11 	11 	Q  -   	 -   	 Q  -    -   	 Q  -   	
G  11 	 11 	N  -    -   	N  -   	 -   	 N  -    -   	 N  -   	
C  -    -   	C  -    -   	C  -   	 -   	 C  -    -   	 C  -   	
D  -    -   	D  -    -   	D  -   	 -   	 D  -    -   	 D  -   	
F  -    -   	F  -    -   	F  -   	 -   	 F  -    -   	 F  -   	
K  -    -   	K  -    -   	K  -   	 -   	 K  -    -   	 K  -   	
L  -    -   	L  -    -   	L  -   	 -   	 L  -    -   	 L  -   	
M  -    -   	M  -    -   	M  -   	 -   	 M  -    -   	 M  -   	

Result 	 1 	 27 
Result 	 2 	 22 
Result 	 3 	 14 
Result 	 4 	 11 

Total 1		 74 (For 8 row data)



Get 4 row data 														
Proc 1 	 Res 1 	 Proc 2  Res 2 	 Proc 3  Res 3 	 Finish for 4 row data
A  610 	 411 	 A  411  376 	 A  376  347 	 A  347  345 
E  234 	 35 	 O  104  69 	 O  69 	 40 	 O  40 	 38 
J  228 	 29 	 H  66 	 31 	 H  31 	 2 	 R  6 	 4 
I  199 	 -   	 E  35 	 -   	 J  29 	 -   	 H  2 	 -   
O  104 	 104 	 J  29 	 29 	 R  6 	 6 	 J  -    -   
H  66 	 66 	 R  6 	 6 	 E  -    -   	 E  -    -   
R  6 	 6 	 I  -    -   	 I  -    -   	 I  -    -   
B  -   	 -   	 B  -    -   	 B  -    -   	 B  -    -   
G  -   	 -   	 G  -    -   	 G  -    -   	 G  -    -   
P  -   	 -   	 P  -    -   	 P  -    -   	 P  -    -   
Q  -   	 -   	 Q  -    -   	 Q  -    -   	 Q  -    -   
N  -   	 -   	 N  -    -   	 N  -    -   	 N  -    -   
C  -   	 -   	 C  -    -   	 C  -    -   	 C  -    -   
D  -   	 -   	 D  -    -   	 D  -    -   	 D  -    -   
F  -   	 -   	 F  -    -   	 F  -    -   	 F  -    -   
K  -   	 -   	 K  -    -   	 K  -    -   	 K  -    -   
L  -   	 -   	 L  -    -   	 L  -    -   	 L  -    -   
M  -   	 -   	 M  -    -   	 M  -    -   	 M  -    -   

Result 	 1 	 199 
Result 	 2 	 35 
Result 	 3 	 29 
Result 	 4 	 2 
		
Total 2 	 265 (For 4 row data)

How to get this data using Query or Function? And how to using in PHP?
Please help!

Thank you.
Jimmy

modified 5-Dec-12 2:24am.

Create a connection to the database (unknown as you did not name it)
Create a query to extract the data from the unknown database
Put the results of the query in your collection (PHP and is nothing to do with the database)

So the only relevant information you have given us is PHP in a DATABASE forum! Find a tutorial about PHP and your unknown database and work through the tutorial. Come back and ask SPECIFIC questions when you have trouble!

Never underestimate the power of human stupidity
RAH

Hi, Mycroft Holmes
Thank for reply.

You means the data can not using Query (MySQL) but use PHP.
Okay I move this forum to Web development. But how to move this topic to Web Development?

Thanks