Trick! Update your Products Ordered count

[argv64]

Sometimes the count of the "products ordered" (table: products, field: products_ordered) is not real. It contains the user installation order test, delete orders or others irrelevant orders. Easy to solve, next query update the product_ordered counting the order table.

Query to update the product_ordered, execute it in your MySQL Query Manager (like PhpMyAdmin)

UPDATE products 

SET products_ordered = (

	SELECT SUM( products_quantity ) AS total

    FROM orders_products

    WHERE orders_products.products_id = products.products_id

    GROUP BY products_id)

[/PHP]

Good luck and Good night!

[b]Other trick in: [/b]

http://www.albertserra.cat

- Manufacturers in product detail (product_info)

- Show the customer phone in print orders

- Custumer name in cart box

- Prototype & Scriptaculous to build a Banner in a homepage

--

Albert Serra

Senior PHP Developer

[email][email protected][/email]

[email][email protected][/email]

http://www.senior-php-developer.com/

http://www.albertserra.cat/