assuming these are your fields:
code would look something like:
$query = "select count(post_id) as Admin1 where
$result = mysql_query($query);
$object = mysql_fetch_object($result);
$Admin[$i] = $object -> admin_id;
print("Admin $i has $Admin[$i] posts.");
Sandler & Travis Trade Advisory Services, Inc.
248.474.7200 x 183
From: Dave Carrera [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 8:03 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Count and group ?
I have added a row to my table which inputs which admin user has amended
a record in a table on my db.
I have this working but what I would like to do is count how many
instances of the admin id I have stored.
So if my list looks like this..
Then the result I would like to display is this..
Admin (1) = 3 posts
Admin (2) = 4 posts
Admin (3) = 5 posts
Basically displaying the total post each admin has made
Any help or guidance is very appreciated and thank you in advance
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php