Jump to content


Photo

Problems with a COUNT query


  • Please log in to reply
2 replies to this topic

#1 fluff

fluff
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 29 April 2003 - 11:23 AM

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

#2 fluff

fluff
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 29 April 2003 - 11:54 AM

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?

#3 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 29 April 2003 - 02:44 PM

eee... that would be nasty. do you have to run one query? can you not use a separate query for each count?
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users