show amount month wise for multiple entry....?
let me tell you what i am doing..i have insertion query on selection of
checkboxes means that the query will insert the entries as many as number
of checkboxes selected. see the image
according to image if i selected month from sep to march then the fixed
amount for subscription will insert into database 7 times each as per
number of check box selected it mean according to my entries inserting
seven times...Okay this is working fine..
Now..I just want to show these amount on my front page accordingly
month... Ex. if current month is sep fixed amount=150 //fixed amount in
database if current month is oct then fixed amount =300 //it will add
previous amount too and the amount for each monnth is fixed as 150.
Now have a look of my database entry for further understanding..
Now how to do this and display amount for each current month and amount
will go increase for oct, nov.......march.
feel free to ask if i missed something regarding explanation of my problem...
Help!! and thanks in advance......
No comments:
Post a Comment