Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › How do I save the total number of items in a cart into database?

View all replies to this thread

How do I save the total number of items in a cart into database?

Thread began 2/24/2010 6:12 am by info4753 | Last modified 3/02/2010 11:09 am by info4753 | 1289 views | 5 replies

2/24/2010 1:12 pmDani Chankhour

Instead of storing the number of items in the order, you could modify the query that is going to display the number of items by using the Count() function which will return the number rows.

Here is query example:

SELECT t1.OrderID, t2.DetailOrderID, COUNT(t1.OrderID) as tot
FROM ps3_orders as t1 INNER JOIN ps3_orderdetails as t2 on t1.OrderID = t2.DetailOrderID WHERE t1.OrderID = 1

Let me know if you have additional questions.

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.