Re: newbie php/mysql need help
| From: | Burhan Khalid | Date: | Mon, 14 Mar 2005 06:04:43 +0000 |
| Subject: | Re: newbie php/mysql need help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-210644@lists.php.net to get a copy of this message | ||
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'];
}