prepare("SELECT * FROM download_level_1 WHERE active = 1 and cfg_site_id = ".SITE_ID." ORDER BY dl1_id ASC");
$level_1 -> execute();
while ($dl1 = $level_1-> fetch(PDO::FETCH_ASSOC))
{
?>
=$dl1['title']?>
query("SELECT count(1) FROM download_level_2 WHERE active = 1 and dl1_id = ".$dl1['dl1_id']."")->fetchColumn();
if($num_dl1 > 0)
{
echo "";
$level_2 = $conn->prepare("SELECT * FROM download_level_2 WHERE active = 1 and dl1_id = ".$dl1['dl1_id']." ORDER BY dl1_id ASC");
$level_2 -> execute();
while ($dl1 = $level_1-> fetch(PDO::FETCH_ASSOC)){
?>
";
}
} // end if dl 1
?>