Re: newbie php/mysql need help

[Burhan Khalid <phplist@xxxxxxxxxxxx>]

p80 wrote:
> I do a mysql request like this one:
>
> SELECT DISTINCT (brand), COUNT( brand )FROM `machines` where category like 
> 'sold' group by brand"

Try adding aliases to your query, such as :

SELECT DISTINCT (brand), COUNT (brand) AS brand_count FROM `machines` 
WHERE `category` LIKE 'sold' GROUP BY `brand`

Then, you can echo the result thusly:

while($row = mysql_fetch_assoc($result))
{
   echo $row['brand'];
   echo $row['brand_count'];
}

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php