Jump to content


Photo

Help! Need to retreive order number!


  • Please log in to reply
2 replies to this topic

#1 visions

visions
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 25 August 2004 - 04:44 AM

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.

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 25 August 2004 - 11:34 PM

could do with some code mate, u can always put the variable into a hidden form or grab it from http var.
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#3 morpheus.100

morpheus.100
  • Members
  • PipPipPip
  • Advanced Member
  • 145 posts

Posted 29 August 2004 - 08:59 AM

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.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users