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?

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