Result links with numbering

[jamesmiddz]

Hi, Can anyone help here.

I have 'cobbled' together this piece of code that is incredibly non-economic. Does anybody know of a quick way of doing this?

/////////////////////////////////

$rTotal1 = "SELECT COUNT(*) AS count FROM countries WHERE county='Carlow' ";
$rTResult1 = mysql_query($rTotal1);
$returnObj1 = mysql_fetch_object($rTResult1);

$rTotal2 = "SELECT COUNT(*) AS count FROM countries WHERE county='Cavan' ";
$rTResult2 = mysql_query($rTotal2);
$returnObj2 = mysql_fetch_object($rTResult2);

$rTotal3 = "SELECT COUNT(*) AS count FROM countries WHERE county='Clare' ";
$rTResult3 = mysql_query($rTotal3);
$returnObj3 = mysql_fetch_object($rTResult3);

$rTotal4 = "SELECT COUNT(*) AS count FROM countries WHERE county='Cork' ";
$rTResult4 = mysql_query($rTotal4);
$returnObj4 = mysql_fetch_object($rTResult4);

Carlow = <? if($returnObj1->count ==0) { echo "No Results"; } else echo"$returnObj1->count" ;?>
Cava = <? if($returnObj2->count == 0) { echo "No Results"; } else echo"$returnObj2->count" ;?>
Clare = <? if($returnObj3->count == 0) { echo "No Results"; } else echo"$returnObj3->count" ;?>
Cork = <? if($returnObj4->count == 0) { echo "No Results"; } else echo"$returnObj4->count" ;?>

////////////////////////////////////////

Basically I'd like to see something like this:

Carlow = 15
Cava = 42
Clare = No Results
Cork = 5

Regards, James

[devinemke]

$sql = 'SELECT county, COUNT(*) AS count FROM countries GROUP BY county';
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result))
{
	echo $row['county'] . ' = ' . $row['count'] . '<br>';
}

[jamesmiddz]

Hey Divinemike....great stuff, you've saved the day!

Funnily enough I was messing around with count and group in a query - thought it kinda logically - I think my syntax wasn't right, couldn't get it to work.

Your code is sooo simple, did the trick. I'm self taught, so there are a few gaps in my abilities to economise on code.

Good, I start chopping out oceans of code from my current website and put this into place.

If you get a chance visit my site at:

www.shmootcase.co.uk

BIG thanks

James