$result = @mysql_query("SELECT id, link FROM jos_menu WHERE published='1' ORDER BY id DESC"); 
    while ($sonuc = @mysql_fetch_assoc($result)) 
    { 
    $xml_ciktisi .= "\n 
 <url>\n<loc>http://www.siteadi.com/".$sonuc['link']."&Itemid=".$sonuc['id']."</loc>\n 
    <changefreq>monthly</changefreq>\n 
    <priority>0.60</priority>\n</url>"; 
    }
    echo $xml_ciktisi ."\n</urlset>";