Lets say my database has some useful widget information in different tables as follows...
~ Widget title
~ Widget brand
~ Widget distributor
There are many brands which are in turn available from many distributors.
How would I print a list of brands that are available by at least TWO or more distributors?
$sql = "SELECT DISTINCT(distributor) FROM `".$config_databaseTablePrefix."widgets` ORDER BY distributor";
if (database_querySelect($sql,$rows))
{
foreach($rows as $product)
{
$item = array();
$item["name"] = $product["distributor"];
From there... how would I implement a check to see if a brand has at least 2 distributors?