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=arch...@jab.org
