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.
Help with Generating invoice number with PHP
Moderator: General Moderators