-
0 group by partnerid order by REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(
REPLACE(firma, 'Ä', 'A'), 'Ö', 'O'), 'Ü', 'U'),
'ä', 'a'), 'ö', 'o'), 'ü','u'), 'ß', 's')";
} else if ($selregion and $selregion != 'de') {
$sql = "select * from $partnertable where region = '$selregion' $where and geloescht = '' and partnerid > 0 group by partnerid order by REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(
REPLACE(firma, 'Ä', 'A'), 'Ö', 'O'), 'Ü', 'U'),
'ä', 'a'), 'ö', 'o'), 'ü','u'), 'ß', 's')";
} else {
$sql = "select * from $partnertable where partnerid = '$id' and partnerid > 0 $where";
}
$rec2 = $mysqli->query($sql);
while($row2 = $rec2->fetch_assoc()) {
if ($row2[partnerid] == 119) {
continue;
}
$sql = "select * from $partnertable where partnerid = '$row2[partnerid]' $where order by id desc";
$rec = $mysqli->query($sql);
$row = $rec->fetch_assoc();
if (!$row[datei]) {
$row[datei] = '/uploadfiles/cardegylogo.png';
}
if ($row[strasse] ) {
$adresse = "$row[strasse] $row[hausnr], $row[plz] $row[ort]";
} else {
$adresse = "$row[plz] $row[ort]";
} ?>
-
" />
100) { echo substr($row[rabatt],0,100) . ".."; } else { echo $row[rabatt]; } ?>