Keith:
Does this work?
SELECT products_date_available, COUNT(products_quantity)
FROM products
WHERE products_quantity > 0
GROUP BY products_date_available
Hope this helps,
Bob
On May 12, 2010, at 3:06 PM, Keith Clark wrote:
> On Wed, 2010-05-12 at 10:13 -0400, Keith Clark wrote:
>> Chris,
>>
>> Here is my full table definition:
>>
>> CREATE TABLE `products` (
>> `products_id` int(15) NOT NULL AUTO_INCREMENT,
>> `products_quantity` int(4) NOT NULL,
>> `products_model` varchar(15) NOT NULL DEFAULT '',
>> `products_image` varchar(64) DEFAULT NULL,
>> `products_price` decimal(15,4) DEFAULT NULL,
>> `products_date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
>> `products_last_modified` datetime DEFAULT '2008-10-01 00:00:00',
>> `products_date_available` datetime DEFAULT '2008-10-01 00:00:00',
>> `products_weight` decimal(5,2) DEFAULT '0.50',
>> `products_status` tinyint(1) NOT NULL DEFAULT '1',
>> `products_tax_class_id` int(11) DEFAULT '1',
>> `manufacturers_id` int(11) DEFAULT NULL,
>> `products_ordered` int(11) DEFAULT '0',
>> `products_format` varchar(20) DEFAULT NULL,
>> `abebooks_price` decimal(15,4) DEFAULT NULL,
>> PRIMARY KEY (`products_id`,`products_model`),
>> UNIQUE KEY `products_model` (`products_model`),
>> KEY `idx_products_date_added` (`products_date_added`),
>> KEY `manufacturers_id` (`manufacturers_id`)
>> ) ENGINE=MyISAM AUTO_INCREMENT=17418 DEFAULT CHARSET=latin1
>>
>> So, I'd like to create a report that grouped by products_date_available,
>> counts all records before products_date_available with a
>> products_quantity>0.
>>
>>
> I don't think I'm asking this question properly.
>
> For every date in products_date_available in the table, I'd like to know
> the count of items available with products_quantity>0 up until that
> date.
>
> So if there are 500 days in the table, there should be 500 rows in the
> report. Each showing the products available as of that date in time.
>
> I hope that clarifies it. I can write a query to do so for each
> individual date, just not a report for all dates at the same time.
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=bobc...@earthlink.net
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
