Well, i think this will work perfectly, i will try it out.
And yes, Invoice Bubble, is a good application…, Sadly i didn’t make it, So i am making one right now.
3. Display grand total : i don’t know how to do this…(ran our of ideas)
select sum(qty * price) as total FROM invoiceItems WHERE invoiceid = 2
i think u can then adapt this to your use?
somehow i think u might be better off asking programming related stuff at more specific forums like StackOverflow or MySQL Forums? noone really answered your question directly.