RE: [PHP] newbie php/mysql need help

[Robbert van Andel]

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:[EMAIL PROTECTED] 
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

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