Hello,
<[EMAIL PROTECTED]> wrote:
>
> 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'];
You can find something about "aliases" here:
http://www.mysql.com/doc/en/SELECT.html
- E
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
