Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › eCart3_OrderID - is not being saved in session and orderdetail table.

View all replies to this thread

eCart3_OrderID - is not being saved in session and orderdetail table.

Thread began 8/05/2014 11:46 am by Art | Last modified 8/05/2014 1:57 pm by Art | 2297 views | 10 replies

8/05/2014 1:12 pmJason ByrnesWebAssist

both of those ID fields are varchar. That doesn't matter, does it?

yes, it does matter, the ID fields must be integers.

in the orders table, the ID field needs to also be set to auto increment.

The code uses mysql_insert_id(); to look up the auto increment value when the record is inserted.

if you have the ID column set to varchar, it wont be able to auto increment, it needs to be an integer to be able to auto increment.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.