Subtotal Are Not Coming…. 01.09.08
Dated: 1.09.09
Dear Sir,
Following is my query regarding getting subtotals of fields after quick search or filter search records in one database and one table.
Following is the online link:
http://www.kashmirvastralaya.com/PentsShirts/PentsShirts_view.php
I wish to know the php mysql 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
