is there a problem with msql count in php

[Trojan]

hey there peeps

i just want to know if there is a prob with the myqsl count function in sql. the sql statement that i have got is fine but when i put it in the php file it does not work.

$sql2 = "SELECT Services.LocationID, count(CabID) FROM Services WHERE Services.LocationID =\"$locID\" GROUP BY Services.LocationID";

$sql_result2 = mysql_query($sql2, $connection) or die ("Could nt exeecute 2nd query");

$row2 = mysql_fetch_array($sql_result2);

$total = $row2[0];

the thing is $total does not come up with the count value but the id number instead!!!

anyone got any ideas why or is it just me!!

[jburfield]

$total should be this:

$total = $row2[1];

$row2[0] IS the id number according to your query.

-- Jason