$depan->sql = "select id,left(album,25) as album from album where status='1' order by id desc";
$depan->perPage = LIST_PER_PAGE;
$depan->tipe = 2;
$sql = $depan->genSql();
$rProf = $depan->exQ($sql);
if(mysql_num_rows($rProf)>0){
$n = 0;
$listAlbum = array();
while($data = mysql_fetch_array($rProf,MYSQL_ASSOC)){
foreach($data as $k=>$i){
$listAlbum[$n][$k]=$i;
}
$n++;
}
$smarty->assign('paging',$depan->pageMe());
$smarty->assign('pNum',$depan->page);
$smarty->assign("listAlbum",$listAlbum);
// assign 1ist album
if($_GET['id']){
$id= @preg_replace("@[^0-9]@i","",$_GET['id']);
$sql = "select *,date_format(tanggal,'%d %M %Y') as tanggal from album where status='1' and id=$id";
}else{
$sql = "select *,date_format(tanggal,'%d %M %Y') as tanggal from album where status='1' order by id desc limit 1";
}
if($r = $depan->exQ($sql)){
$data = mysql_fetch_array($r,MYSQL_ASSOC);
$smarty->assign("id_album",$data['id']);
$smarty->assign("album",$data['album']);
$smarty->assign("tanggal",$data['tanggal']);
$smarty->assign("deskripsi",str_replace(array("\n","\r"),"<br>",$data['deskripsi']));
