the orderID column in the order table should be set as the primary key column, it should be set to auto increment. the database will handle setting the value for this column, you should bne storing the sessionID in that column.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.