Topic: Help! Need to retreive order number!

[visions]

Hi all,

I'm hoping someone out there can help me out with this as it's got me completely stumped!  

I'm putting together an order system where once the customer submits their order the results are logged to a MySQL database - as each entry gets logged a unique order no is generated by the database (through auto-increment) -

my problem is I need to display the order number on the following page:

eg.  Thanks for your order, your order number is ..........

I've tried everything & can't get the order number value to appear on the confirmation page... any ideas or input would be very much appreciated!  Thanks in advance to anyone who is able to help.  

[shocker-z]

could do with some code mate, u can always put the variable into a hidden form or grab it from http var.

[morpheus.100]

If the column is the ID and it is primary use insert_id

And you can get the insert-retrieve-id ext from DW Team for what use it is.