basis webshop / cataloogje (Opgelost)

<a href="maingroup.php?detail=phones">Phone</a><br>
<a href="maingroup.php?detail=Accessories">Accessories</a><br>
<a href="maingroup.php?detail=Gadgets">Gadgets</a> 

<a href="maingroup.php?detail=phones">Phone</a><br>
<a href="maingroup.php?detail=Accessories">Accessories</a><br>
<a href="maingroup.php?detail=Gadgets">Gadgets</a>

<a href="group.php?detail=mobile">mobile</a><br>
<a href="group.php?detail=fixed">fixed</a><br> 

<a href="group.php?detail=mobile">mobile</a><br>
<a href="group.php?detail=fixed">fixed</a><br>

<a href="subgroup.php?detail=Slidephone">Slidephone</a><br>
<a href="subgroup.php?detail=Candybar">Candybar</a><br> 

<a href="subgroup.php?detail=Slidephone">Slidephone</a><br>
<a href="subgroup.php?detail=Candybar">Candybar</a><br>

SELECT distinct maingroup from articles

SELECT DISTINCT maingroup FROM articles

SELECT DISTINCT subgroup from articles where maingroup='phones'

SELECT DISTINCT subgroup FROM articles WHERE maingroup='phones'

$aanroep = 2.1.3;
$groups = explode(".", $aanroep);

$aanroep = 2.1.3;
$groups = explode(".", $aanroep);

$maingroup = mysql_query("SELECT DISTINCT maingroup FROM articles"); 
while ($obj = mysql_fetch_object($maingroup)) { 
  echo $obj->Voornaam." "; 
  echo $obj->Achternaam."<br />"; 
} 
mysql_free_result($maingroup); 

$maingroup = mysql_query("SELECT DISTINCT maingroup FROM articles"); 
while ($obj = mysql_fetch_object($maingroup)) { 
  echo $obj->Voornaam." "; 
  echo $obj->Achternaam."<br />"; 
} 
mysql_free_result($maingroup);

<?php
$dbserver = "localhost";
$user = "********"; 
$passwd = "******";
$dbnaam = "**********";
$link = mysql_connect($dbserver, $user, $passwd) or die("No connection");
$db = mysql_select_db($dbnaam,$link) or die("No connection"); 

$maingroup = mysql_query("SELECT DISTINCT maingroup FROM products");
	while ($obj = mysql_fetch_object($maingroup)) {
		echo $obj->group." ";
		echo $obj->subgroup."<br />";
	}
mysql_free_result($maingroup);
mysql_close($link) or die("Can't close");

?> 

<?php
$dbserver = "localhost";
$user = "********"; 
$passwd = "******";
$dbnaam = "**********";
$link = mysql_connect($dbserver, $user, $passwd) or die("No connection");
$db = mysql_select_db($dbnaam,$link) or die("No connection"); 
 
$maingroup = mysql_query("SELECT DISTINCT maingroup FROM products");
	while ($obj = mysql_fetch_object($maingroup)) {
		echo $obj->group." ";
		echo $obj->subgroup."<br />";
	}
mysql_free_result($maingroup);
mysql_close($link) or die("Can't close");
 
?>

mysql_query("SELECT DISTINCT * FROM products");

mysql_query("SELECT DISTINCT * FROM products");

<?php
$dbserver = "localhost";
$user = "*****"; 
$passwd = "*****";
$dbnaam = "e-meel_be_producten";
$link = mysql_connect($dbserver, $user, $passwd) or die("No connection");
$db = mysql_select_db($dbnaam,$link) or die("No connection"); 
//
$maingroup = mysql_query("SELECT DISTINCT * FROM products");
while ($obj = mysql_fetch_object($maingroup)) {
	echo "<a href='onbestaandepagina.php?group=$obj->maingroup'>$obj->maingroup</a><br>";
	}
//
mysql_close($link) or die("Can't close");
?> 

<?php
$dbserver = "localhost";
$user = "*****"; 
$passwd = "*****";
$dbnaam = "e-meel_be_producten";
$link = mysql_connect($dbserver, $user, $passwd) or die("No connection");
$db = mysql_select_db($dbnaam,$link) or die("No connection"); 
//
$maingroup = mysql_query("SELECT DISTINCT * FROM products");
while ($obj = mysql_fetch_object($maingroup)) {
	echo "<a href='onbestaandepagina.php?group=$obj->maingroup'>$obj->maingroup</a><br>";
	}
//
mysql_close($link) or die("Can't close");
?>