PHP and MySQL sorting using COUNT
| From: | ed at home dot homes2see dot com | Date: | Wed, 13 Nov 2002 13:44:06 +0000 |
| Subject: | PHP and MySQL sorting using COUNT | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-124213@lists.php.net to get a copy of this message | ||
I'm sorting records using COUNT with the following mysql command
$result = mysql_query ("SELECT company_name, agent_name, count(*) FROM
$cur_listings GROUP BY company_name, agent_name");
Running this in MySQL does exactly what I need it to do but how do I echo
the COUNT portion of the array? I know the company_name would be
$row['company_name'] and agent_name is $row['agent_name'];
Thanks,
Ed Curtis