query("select name from photo_category where id='$id'"); while($row = $stmt -> fetch(PDO::FETCH_ASSOC)){ $categoryid=$id; $categoryname=$row["name"]; } Template::assign("categoryid", $categoryid); Template::assign("categoryname", $categoryname); $stmt = $pdo1->query("select * from gallery order by no desc"); while($row = $stmt -> fetch(PDO::FETCH_ASSOC)){ $list[]=$row; } Template::assign("alllist", $list); Template::display("gallery.tpl"); ?>