Hi all, I appear to be having a couple of difficulties with my database query. When I use it as follows, it works perfectly.
However I want to add up all of the quantity fields to produce a total number of shopping cart items. I've used the following which does produce a total of all items but I no longer have all the rows, just one!
Any help is appreciated as always :)