Dated: 29.08.08

Dear Sir,

Following is my query regarding getting subtotals of fields after quick search or filter search records in one database and one table. I wish to know the php code for getting sub total of field or many fileds at a time when we quick search or filters search records in one database and one table. I am providing my problem below.
Item...................Qty...........Rate......Amo unt
ShirtsGreen...........87...........234.......20358
ShirtsBrown..........50 ...........250.......12500
ShirtsGreen..........154...........287.......44198
ShirtsWhite..........100...........275.......27500
ShirtsGreen..........150...........215.......32250
PentsGreen..........144...........483.......69552
PentsWhite..........100...........450.......45000
PentsGreen..........200...........350.......70000
PentsBrown..........125...........450.......56250
PentsGreen...........67............446.......29882

Now sum of above Amount field is coming 407490 by qsum php mysql code.

But now I have one more problem when we quick search or filter search above fields to either ShirtsGreen then it is not showing Qty & subtotal of shirtsGreen i.e Qty 391 & Subtotal 96806 and when we quick search or filter search for pentsGreen then it is not showing Qty & subtotal of pentsGreen i.e Qty is 411 & Subtotal Amount is 169434. Pl. provide me php-mysql code for this, If any body can help in this matter, pl. help me. I shall be very much thankful for this.

I request to all of you to solve my this problem.

Thanks with Regards
KKSingh

Why not try an SQL or MySQL forum?

Sorry, I don't understand what you are looking for, please give more more info

For More Detail Pl. see the below online link:

http://www.kashmirvastralaya.com/Pen...hirts_view.php

Pl. provide the php mysql code for solving this above problem.

Thanks,
Regards,
KKSingh1957