Re: Creating a hash of arrays from DB results (db)

Of course, the real solution is to let the DB do the work:

SELECT stamp,
       COUNT(*)
  FROM Table
 WHERE state = "In Use"
 GROUP BY stamp
[download]

I think that won't give stamps with zero "In Use". I think you'll need a subquery if you want that result.

Comment on Re: Creating a hash of arrays from DB results (db) Download Code

Replies are listed 'Best First'.
Re^2: Creating a hash of arrays from DB results (db) by blaze (Friar) on Oct 05, 2009 at 21:20 UTC
You guys rock, thanks a million! excellent catch ikegami!!	[reply]