how to add session cart table in database and give all ordered items one unique orderid?
<pre><code>ProductName     price   brand   Quantity    Net   AmountNet   Amount    Update
</code></pre>

<p>I have the above table in which I have to insert the products which users have added to their cart.
Users can add multiple products to their cart.
I have that table of user added products in the session and I am reading it row by row by taking that session table as a datatable.
I have to insert all products row by row in above table.</p>

<p>I also have another table as follows:</p>

<pre><code>orderID    CartItemID   RegistrationID   OrderDate   NetAmount  Remarks   Created
</code></pre>

<p>My question is, how to give one unique order id to all products ordered by a user?</p>
