0

Hello Everybody...
From last three days i m posting my queries but no one take it seriously, please if u people dont mind than plz help me....
i m be very thankful in future.

In my database i have 6 fields and through html form i requested only three of them, particualrs, debit and credit which is already correct and work properly. But now my question is that how i can insert the sum_of_debit , sum_of_credit and balance (sum_of_credit - sum_of_debit) without using the html form just using of queries.

---------------------------------------------------------------------
|particulars| debit | credit | sum_of_debit | sum_of_credit| balance |
| abc | 25 | 30 | 25 | 30 | 5 |
| xyz | 15 | 40 | 40 | 70 | 30 |
| | | | | | |
| | | | | | |
----------------------------------------------------------------------

***With Best Reg@rds***

3
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by ismael ahm@d
0

why you are using sum_of_debit, sum_of_credit columns as it holds same value as debit and credit column.

If you want to automatically insert balance, then post your insert query code. you need to modify your insert query for auto updation and without html values.

Edited by urtrivedi: n/a

0

table design seems wrong
as a transaction table there should be no totals
as a totals table there should be no transactions
there is no indexed column to link it to the customer table
what are you actually trying to accomplish

0

why you are using sum_of_debit, sum_of_credit columns as it holds same value as debit and credit column.

If you want to automatically insert balance, then post your insert query code. you need to modify your insert query for auto updation and without html values.

thanks on replying...

Dear i actually wana that after the multiple values of debit or credit first add on each row then display the whole figure on the balance field, so that way i created the above mentioned fields, if u have proper idea to solve without using the sum_of_debit and sum_of_credit, then plz share it with me.....

Thanks

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.