query($query_main_topic);
while ($row_main_topic = $result_main_topic->fetch(PDO::FETCH_ASSOC))
{
$main_topic_id=$row_main_topic['id'];
$main_topic_name=$row_main_topic['name'];
$main_topic_bez=$row_main_topic['bezeichnung'];
echo "";
}
?>
Anbieter $main_topic_name
- ";
$query_comp="Select company.name as comp_name,
company.id as comp_id,
company.content_id as content_id,
company.main_topic_id as main_topic_id,
content.bezeichnung as cont_bez
from company
left join (select * from content
where content.website_id=$website_id
and content.valid_from <= NOW()
and content.valid_till >= NOW()
) as content on company.content_id=content.content_id
Where company.main_topic_id=$main_topic_id
and company.content_id<>'0'
Order by company.name";
$result_comp = $connection->prepare($query_comp);
$result_comp->execute(array('website_id'=>$website_id, 'main_topic_id'=$main_topic_id));
while ($row_comp = $result_comp->fetch(PDO::FETCH_ASSOC))
{
$main_comp_name=$row_comp['comp_name'];
$main_comp_bez=$row_comp['cont_bez'];
$main_comp_id=$row_comp['comp_id'];
$main_comp_content_id=$row_comp['content_id'];
$main_comp_main_topic=$row_comp['main_topic_id'];
echo "
- $main_comp_name "; } echo "