Page 1 of 1

Help with Generating invoice number with PHP

Posted: Mon Nov 23, 2009 3:26 am
by afam4eva
Pls i need help with generating an invoice no for my website. Currently i made use of the sql function "create table order(invoice_no serial auto_increment)" to generate unique invoice numbers. But my problem is that the invoice number does not display on the page except i reload the browser.

Let me make it more lucid to you.

For example you cannot "insert into orders(invoice) values('')" and also "select * from orders" on the same page. So what options do i have left.