most occurances

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I have a table called items with a field "brandid"

I'm using mysql 3.23.58 which does not have COUNT();

What statement can I use to find out which brandid occurs the most  


Re: most occurances

meltedown wrote:
Quoted text here. Click to load it
I read in the manual that there is no COUNT() before 4.1.1, but I got  
this to work, so I don't know aht the problem was.

$query2="SELECT brandid FROM items GROUP BY brandid ORDER BY COUNT(*)  

Site Timeline