Hi all,
I have several tables from which I have to fetch certain products
categories based on customer selection. The tables are as follows:
Table 1 - Categories
catid (autonum)
catname
Table 2 - Sub categories
subcatid (autonum)
subcatname
Table 3 - Products
prodid (autonum)
prodname
Table
Hi all,
I'm trying to add all the values from the same column in MySQL with a
query like this:
SELECT SUM(colname) WHERE value = 'value'
But then I can't output it on the screen correctly. I've tried to put
all the results into an array and then make an array_sum($arrayname) and
it gives me
Hi all,
I have this table which stores products and quantities ordered by
customers, and for billing purposes, I need to fetch not only how many
products but also how many where ordered for each one but not detailed,
but as one big result, so later I can charge for individual gift
packages and