Hi there people:

I have a MySQL table consisting of category names among other things. 
I would like to be able to construct a query that tells me the number of times a 
unique category 
name occurs in the table:

//Table 'posts' from command-line
mysql> explain posts;
+----------+-------------+------+-----+------------+----------------+
| Field    | Type        | Null | Key | Default    | Extra          |
+----------+-------------+------+-----+------------+----------------+
| id       | tinyint(3)  |      | PRI | 0          | auto_increment |
| category | varchar(25) |      |     |            |                |
| user     | varchar(12) |      |     |            |                |
| dateFrom | date        |      |     | 0000-00-00 |                |
| dateTo   | date        |      |     | 0000-00-00 |                |
| title    | varchar(25) |      |     |            |                |
| body     | text        |      |     | NULL       |                |
+----------+-------------+------+-----+------------+----------------+
7 rows in set (0.00 sec)

//Table 'posts' in phpMyAdmin tab
id category      user        dateFrom    dateTo      title            body 
3  some stuff    maurice     2001-09-23  2001-11-05  Maurcie's post   this is 
Maurice's test
4  russ category russmichell 2001-08-17  2001-08-27  Russ is theone   this is another 
test
9  russ category russmichell 2001-08-16  2001-08-19  Begon by Monday! This entry 
should dissapear
10 russ category russmichell 2001-08-16  2001-09-04  testing          This is another 
test!

For example I would like to know how many posts there are in the category 'russ 
category' (Should 
tell me there are 3 and only 1 for 'some stuff' ...

Can anyone help me toward a nice SQL query that would to this for me!?
Cheers all.

Russ

#-------------------------------------------------------#
                                
  "Believe nothing - consider everything"       
  
  Russ Michell
  Anglia Polytechnic University Webteam
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam
  t: +44 (0)1223 363271 x 2331

  www.theruss.com
                        
#-------------------------------------------------------#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to