Posted by Robbert van Andel on 03/14/05 00:45

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

[Back to original message]