Akční odjezdy platné k

 

Query_To_Array("SELECT z.*, o.zadavatel, o.scenou, o.id AS zadavatelid FROM reklama_bus_zastavka AS z INNER JOIN reklama_bus_linka AS l ON z.linkaid = l.id INNER JOIN odjezdy_reklama AS o ON l.owner = o.id WHERE z.active = 1 AND z.cena IS NOT NULL ORDER BY z.nazev"); foreach($zastavky as $zastavka){ $linka = $db->Query_To_Array("SELECT cislo FROM reklama_bus_linka WHERE id = {$zastavka['linkaid']}"); echo ""; } ?>

Odjezd do	Info		Cena od	Přepravce	Rezervace
{$zastavka['nazev']}		{$linka[0]['cislo']}"; $linkaNazev = $db->Query_To_Array("SELECT * FROM reklama_bus_zastavka WHERE linkaid = {$zastavka['linkaid']} ORDER BY id"); foreach($linkaNazev as $linkaNazev){ echo " - {$linkaNazev['nazev']}"; } echo "	"; echo ( $zastavka['scenou'] )? "{$zastavka['cena']},{$zastavka['drobne']} {$zastavka['mena']}":"neuvedeno"; echo "	{$zastavka['zadavatel']}	>>