On Fri, Feb 27, 2009 at 11:17 AM, revDAVE <Cool@xxxxxxxxxxxxxxxx> wrote: > Newbie question > > Hi folks, > > Currently, I have an inventory table that stores individual records for > each > single item in inventory - ( each item is on its own line because it has > serial numbers associated with it) like: > > fields: > > Item - ModelID - sn > > > item1 - 1 - sn xxx > item1 - 1 - sn xxx > item2 - 2 - sn xxx > item2 - 2 - sn xxx > item2 - 2 - sn xxx > item3 - 2 - sn xxx > > Goal: I would like to give a report page with total counts for current in > inventory like: > > COUNTS... > item1 = 2 > item2 = 3 > item3 = 1 > > so I created a fool around query that gets a count for just ModelID = 1 > > $query_count_model1 = "SELECT count(inventory_id) as thecount FROM > inventory > WHERE ModelID = 1"; > > BUT: - the I'm sure there is some better way to get a count for *each* of > the ModelID that exist in any given time *all at once* in some kind of loop > or xxx???... I just don't know how do that... > > (newbie alert) - I would appreciate any ideas or URL links etc. - please > keep is simple for this newbie.... > > > > > -- > Thanks - RevDave > Cool @ hosting4days . com > [db-lists 09] > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > select modelId, count(*) as total from table group by modelId -- Bastien Cat, the other other white meat