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.