RE: [PHP] newbie php/mysql need help
| From: | Robbert van Andel | Date: | Sun, 13 Mar 2005 22:45:49 +0000 |
| Subject: | RE: [PHP] newbie php/mysql need help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-210628@lists.php.net to get a copy of this message | ||
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@free.fr]
Sent: Sunday, March 13, 2005 4:35 PM
To: php-general@lists.php.net
Subject: [PHP] 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