fluff Posted April 29, 2003 Share Posted April 29, 2003 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 Link to comment https://forums.phpfreaks.com/topic/412-problems-with-a-count-query/ Share on other sites More sharing options...
fluff Posted April 29, 2003 Author Share Posted April 29, 2003 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? Link to comment https://forums.phpfreaks.com/topic/412-problems-with-a-count-query/#findComment-1382 Share on other sites More sharing options...
effigy Posted April 29, 2003 Share Posted April 29, 2003 eee... that would be nasty. do you have to run one query? can you not use a separate query for each count? Link to comment https://forums.phpfreaks.com/topic/412-problems-with-a-count-query/#findComment-1383 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.