query("SELECT slug FROM posts WHERE status='published'")->fetchAll(PDO::FETCH_ASSOC); foreach($posts as $p)$urls[]=$base.'/post.php?slug='.rawurlencode($p['slug']); echo "\n"; foreach($urls as $u)echo ''.htmlspecialchars($u,ENT_XML1).'weekly0.8'; echo '';