Simple but should work.
$query = " SELECT DISTINCT (brand), COUNT( brand )FROM `machines` where
category like 'sold' group by brand;";
$result = mysql_query($query) or die(mysql_error());
While($data = mysql_fetch_array($result)) {
echo "<p>{$data[0]} - {$data[1]}</p>\n";
}
-----Original Message-----
From: p80 [mailto:p80@xxxxxxx]
Sent: Sunday, March 13, 2005 4:35 PM
To: php-general@xxxxxxxxxxxxx
Subject: newbie php/mysql need help
I do a mysql request like this one:
SELECT DISTINCT (brand), COUNT( brand )FROM `machines` where category like
'sold' group by brand"
I get this from mysql:
brand COUNT( brand)
brandx 4
brandy 12
how can I echo this result in php?
thanx in advance
Pat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
