Re: [PHP-DB] Count and group ?

2002-05-01 Thread Tony James
Hi Dave Assuming you are using mysql try the following query select count(Admin_id) as admin1, Admin_id as admin2 from TABLE_NAME group by admin2 substituting TABLE_NAME for whatever you have called your table. Hope this helps Cheers Tony James - Original Message - From: "Dave

RE: [PHP-DB] Count and group ?

2002-05-01 Thread Ryan Marrs
assuming these are your fields: post_id admin_id code would look something like: admin_id; print("Admin $i has $Admin[$i] posts."); } ?> ___ Ryan Marrs Web Developer Sandler & Travis Trade Advisory Services, Inc. 248.474.7200 x 183 248.4