init()) die(" Can't connect to DataBase"); } $sql="select * from tbl_article where (category_id1 in ('2') or category_id2 in ('2')) and state='published' order by ptime desc limit 20"; $result=$db->select($sql); $output=" http://www.perspektifbaru.com Transkrip wawancara radio mingguan bersama Wimar Witoelar Copyright 2005 Yayasan Perspektif Baru webmaster@perspektifbaru.com ".date("D, d M Y H:i:s")." GMT http://blogs.law.harvard.edu/tech/rss http://www.perspektifbaru.com/html/images/pblogo.gif http://www.perspektifbaru.com "; while(list($key,$val)=each($result)){ $id = $val[id]; $title = stripslashes($val[title]);$title=trim($title); $category_id1 = $val[category_id1]; $category = $db->convert_value(array("table"=>"category","cs"=>"category","cd"=>"id","vd"=>"$category_id1")); //count_comment $count_comment = $db->count_comment($id); $summary = stripslashes($val[summary]);$summary=trim($summary); $ptime = $val[ptime]; $namatamu =stripslashes($val[namatamu]); $edisi =$val[edisi]; $ptime_d=substr($ptime,8,2); $ptime_m=substr($ptime,5,2); $ptime_y=substr($ptime,0,4); $ptime_h=substr($ptime,11,2); $ptime_i=substr($ptime,14,2); $ptime_s=substr($ptime,17,2); $ptime_new=date("D, d M Y H:i:s",mktime($ptime_h,$ptime_i,$ptime_s,$ptime_m,$ptime_d,$ptime_y)); $summary=strip_tags($summary); $summary=eregi_replace(" "," ",$summary); $output .=" http://www.perspektifbaru.com/wawancara/$edisi http://www.perspektifbaru.com/wawancara/$edisi#comments $summary $ptime_new GMT "; #Tue, 03 Jun 2005 09:39:21 GMT } $output .=" "; header("Content-type: text/xml"); echo $output; ?>