Code:
SUBSTRING_INDEX(MerchantProductCategory, '/', 1)
SUBSTRING_INDEX(MerchantProductCategory, '/', 1)
SUBSTRING_INDEX(MerchantProductCategory, '/', 1)
$sql = "SELECT DISTINCT SUBSTRING_INDEX(MerchantProductCategory, '/', 1) AS loesung FROM shop";
$erg = mysql_query($sql) or die(mysql_error());
while ( $row = mysql_fetch_assoc($erg) ) {
echo $row['loesung'] . '<br />';
}
$sql = "SELECT DISTINCT SUBSTRING_INDEX(MerchantProductCategory, '/', 1) AS loesung FROM shop";
$erg = mysql_query($sql) or die(mysql_error());
while ( $row = mysql_fetch_assoc($erg) ) {
echo $row['loesung'] . '<br />';
}
Kommentar