[SOLVED] Counting the biggest number of entries in a field!

[budimir]

I have and ID field in a table and loads of information in it. I would like to count and display number of ID's in that column.

 

So, basiclly, this is what I'd like to get:

 

ID 54 = 13 times in table

ID 16 = 55 times in table

ID 78 = 100 times in table

 

I hope you get what I mean.

 

Please help

[sasa]

SELECT COUNT(*) FROM table GROUP BY ID

[budimir]

Thanks!

[budimir]

SELECT COUNT(*) FROM table GROUP BY ID

 

That's a part of it!!

 

How do I display which is which????

[marcus]

$sql = "SELECT COUNT(*) as highest FROM table GROUP BY ID";
$res = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_assoc($res)){
     echo "ID " . $row['id'] . " has " . $row['highest'] . " occurrences<br>\n";
}

[budimir]

$sql = "SELECT COUNT(*) as highest FROM table GROUP BY ID";
$res = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_assoc($res)){
     echo "ID " . $row['id'] . " has " . $row['highest'] . " occurrences<br>\n";
}

 

For some reason I'm not getting the ID. This is the result "ID has 5 occurrences". Is there any reason why it's not working?

[laffin]

$sql = "SELECT ID,COUNT(*) as highest FROM table GROUP BY ID";

[budimir]

Thanks for this!

 

I just need one more thing. How do I display an ID with the biggest number in field "highest"?

[Bauer418]

SELECT ID,COUNT(*) as highest FROM table GROUP BY ID ORDER BY highest DESC

[budimir]

SELECT ID,COUNT(*) as highest FROM table GROUP BY ID ORDER BY highest DESC

 

Thanks for this. But I need ONLY an ID with the "highest" number.

[budimir]

This would be the solution to my problems.

 

SELECT ID,COUNT(*) as highest FROM obilasci GROUP BY ID ORDER BY highest DESC limit 1

 

Thanks for you effort, guys!!!!!