Subversion-Projekte lars-tiefland.medien

<?
        require "include/common.php";
        $smarty->assign("title",$common["list_of_albums"]);
        $sql="SELECT * FROM $prefix"."albums";
        $a_res=$db->query($sql);
        $id=0;
        while($row=$a_res->fetchRow())
        {
                $albums[$id]["link_id"]=$row["a_id"];
                $albums[$id]["a_name"]=$row["a_name"];
                $albums[$id]["a_year"]=($row["a_year"])?$row["a_year"]:"unbekannt";
                $albums[$id]["a_pic"]=$row["a_pic"];
                $albums[$id]["a_type"]=($row["a_sampler"])?$common["sampler"]:"";
                $id++;
        }
        $smarty->assign("albums", $albums);
        $smarty->display("index.tpl");
?>