Problems with a COUNT query

[fluff]

Does anyone know how I can get a result set, containing a count of instances of variables in a column from one table. I am running MySQL version 3.x therefore can\'t use a UNION

 

SELECT COUNT( page_id ) AS index_count FROM mm_click_count WHERE page_id =\'index\'

 

gives me one of the values, I also need a count for page_id =\'forward\' for example ??

 

Thanks in advance

[fluff]

I managed to get a friends help on the SQL, he suggested the following:

 

SELECT COUNT( TABLE1.page_id ) AS index_count,

COUNT( TABLE2.page_id ) AS forward_count

FROM (SELECT * FROM mm_click_count WHERE page_id =\'index\' ) TABLE1,

(SELECT * FROM mm_click_count WHERE page_id =\'forward\' ) TABLE2

 

But MySQL doesn\'t seem to like this, can anyone help translating this into MySQL syntax?

[effigy]

eee... that would be nasty. do you have to run one query? can you not use a separate query for each count?