How to output COUNT in php array?

[BaseballGraphs]

Hello,

I keep getting the following error when I output the code below: Notice: Undefined property: stdClass::$count

$sql = "SELECT COUNT(name), name FROM searches GROUP BY name";
  $result = mysql_query( $sql );
  while($obj = mysql_fetch_object( $result ) ) {
  $pop_players = array();
  $pop_players['COUNT(name)'] = $obj->count;
  $pop_players['name'] = $obj->name;
  $pop_players_two[] = $pop_players;
  }
 

How can I output COUNT(name) in an array?

Thanks for your assistance.

[johny10151981]

give a new name to the count value as below

SELECT COUNT(name) as cnt, name FROM searches GROUP BY name
 

and try

$obj->cnt;

[BaseballGraphs]

Thanks very much! That works!

[BaseballGraphs]

I am also trying to sort from HIGH to LOW by COUNT(name) or cnt. I seem to only be able to sort by the name...do you have any more suggestions. Here is my code so far:

$sql = "SELECT COUNT(name) as cnt, name FROM searches GROUP BY name DESC LIMIT 10";
  $result = mysql_query( $sql );
  while($obj = mysql_fetch_object( $result ) ) {
  $pop_players = array();
  $pop_players['name'] = $obj->name;
  $pop_players['COUNT(name)'] = $obj->cnt;
  $pop_players_two[] = $pop_players;
  krsort($pop_players_two);
  }
 
foreach( $pop_players_two as $pop_players) { 
[ $pop_players['name']; ] => $pop_players['COUNT(name)'];<br/>
}
?>
 

[BaseballGraphs]

This has been resolved by using ORDER BY.

 $sql = "SELECT COUNT(name) as cnt, name FROM searches GROUP BY name ORDER BY COUNT(name) DESC LIMIT 10";