Php MySql Invoice generation
Posted: Sun Oct 25, 2009 11:55 pm
Hi all,
Please can you help me the below.... m new to php mysql...
I have two tables i.e SUPPLIER(sid, sname, saddress, scantact No) and GOODS(gid, gcategory, gname, gqty, gCost Price, gSelling Price).
In the GOOD RECEIPT page, i enter select details like sname, saddress, scantact No from SUPPLIER Table and insert gcategory, gname, gqty, gCost Price, gSelling Price to the SUPPLIER table .... when i press save i am able to save the data is GOODS table. BUT CAN YOU ALL PLEASE HELP ME ON HOW TO GENERATE INVOICE WHEN I SAVE THE DATA FROM GOOD RECEIPT PAGE. Invoice should contact information like gid, sname,saddress,scontact no, gcategory, gname, gqty, gCost Price, gSelling Price, gCost Price Total, gSelling Price Total). Also the space in the inovice to be signed by the user who issues the invoice.
Please help me with this....
Thanks in advace
Monoj
Please can you help me the below.... m new to php mysql...
I have two tables i.e SUPPLIER(sid, sname, saddress, scantact No) and GOODS(gid, gcategory, gname, gqty, gCost Price, gSelling Price).
In the GOOD RECEIPT page, i enter select details like sname, saddress, scantact No from SUPPLIER Table and insert gcategory, gname, gqty, gCost Price, gSelling Price to the SUPPLIER table .... when i press save i am able to save the data is GOODS table. BUT CAN YOU ALL PLEASE HELP ME ON HOW TO GENERATE INVOICE WHEN I SAVE THE DATA FROM GOOD RECEIPT PAGE. Invoice should contact information like gid, sname,saddress,scontact no, gcategory, gname, gqty, gCost Price, gSelling Price, gCost Price Total, gSelling Price Total). Also the space in the inovice to be signed by the user who issues the invoice.
Please help me with this....
Thanks in advace
Monoj