db_set_active('alisearch');
$table = '
';
$table .= '
';
$query ='SELECT DISTINCT aca_mand_id AS mand_id, aca_adr_id FROM alisearch_address_cat
INNER JOIN alisearch_index ON aca_mand_id = s_mand_id
WHERE aca_cat_id = 1000';
$result_ali = _db_query($query);
$nummer = @mysql_num_rows($result_ali);
while($row_ali = db_fetch_array($result_ali)) {
$query_adr = 'SELECT DISTINCT adr_description1 FROM alisearch_address WHERE adr_mand_id = "'.$row_ali['mand_id'].'" AND adr_id = "'.$row_ali['aca_adr_id'].'"';
$result_adr = _db_query($query_adr);
while($row_adr =db_fetch_array($result_adr)) {
$arr[$row_ali['mand_id']] = $row_adr['adr_description1'];
}
}
if ($arr) {
natcasesort ($arr);
foreach($arr as $k => $v) {
//echo "\nArrayausgabe:".'adr_description1 '.$val['adr_description1'].'adr_description2 '.$val['adr_description2'].'s_mand_id '.$val['s_mand_id'];
//echo '\n'.$val['adr_description1'].' '.$val['adr_description2'].'
';
$table .= '
';
}
}
$table .= '
';
echo $table;
db_set_active('default');
?>