Help with a mysql select query

[golfinggod]

Hi
In need of some help, im trying to get my head round this database problem but cant seem to sort it.

Im looking to query the database so that it goes down the lists and then counts all the rows and then order and displays them in decending order.

Example.

Database rows

car
car
car
car
bus
bus
bus
plane
plane

The page would display

total
car = 4
bus = 3
plane = 2

Any idea how I could code this

Thanks

[Frederick]

$sql = mysql_query("SELECT * FROM tablename GROUP BY type ORDER BY title ASC") or die (mysql_error());
while ($row = mysql_fetch_array($sql)) {
    $cnttypesql = mysql_query("SELECT count(*) FROM tablename WHERE type = ".$row["type"]."") or die (mysql_error());
    $cnttype = mysql_result($cnttypesql,0,0);

echo $row["title"]." = $cnttype<br>\n";
}

[golfinggod]

Thanks for the reply but i am still a little stuck. Could you help me place the correct values into the fields

$sql = mysql_query("SELECT * FROM vis_java GROUP BY type ORDER BY title ASC") or die (mysql_error()); 
while ($row = mysql_fetch_array($sql)) { 
    $cnttypesql = mysql_query("SELECT count(*) FROM tablename WHERE type = ".$row["type"]."") or die (mysql_error()); 
    $cnttype = mysql_result($cnttypesql,0,0); 

echo $row["title"]." = $cnttype<br>\n"; 

My table name is vis_java, I have two headers within that called ID and Java. Its the Java field that needs to be order because each line has one of two values either "true" or "false".