bigdspbandj Posted September 13, 2007 Share Posted September 13, 2007 I need to display counts for records meeting a certain criteria: Customer 1 - 11 jobs currently printed Customer 2 - 20 jobs currently printed I have a table that stores every job. This table has fields for customer name and it's current status. I originally looped a mysql count query, but I feel there is a more efficient way of retrieving this type of data without making so many queries. Someone mentioned making a new table that stores the counts, but I am having trouble wrapping my head around how to update that table automatically. Any ideas? Thanks. Quote Link to comment Share on other sites More sharing options...
sasa Posted September 13, 2007 Share Posted September 13, 2007 SELECT cust_name, count(*) AS number FROM table_jobs WHER current_status='printed' GROUP BY cust_name Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.