Sitemap Hazırlamama Yardımcı Olur Musunuz?

<?php
    include("ayar.php");
    //ayar dosyası oluşturun ve include edin
    header('Content-type: text/xml');
    echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n";
    echo "<urlset xmlns=\"http://www.google.com/schemas/sitemap/0.84\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"> xsi:schemaLocation=\"http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd\">";
    $cikti .= "\n<url>\n<loc>http://www.codeboot.com</loc>\n<changefreq>daily</changefreq>\n<priority>1.00</priority>\n</url>";
    //sqlden alınmayan statik sayfalar el ile girilir
    $cikti .= "\n<url>\n<loc>http://www.codeboot.com/archive</loc>\n<changefreq>daily</changefreq>\n<priority>1.00</priority>\n</url>";
    $cikti .= "\n<url>\n<loc>http://www.codeboot.com/random</loc>\n<changefreq>daily</changefreq>\n<priority>1.00</priority>\n</url>";
    $cikti .= "\n<url>\n<loc>http://www.codeboot.com/contact</loc>\n<changefreq>daily</changefreq>\n<priority>0.80</priority>\n</url>";
//sql sorgunuzu düzenleyin limiti belirtin
$result=mysql_query("select * from tablom order by id DESC LIMIT 150");
while ( $veri = mysql_fetch_array($result))
{
$ID=$veri['video'];
$baslik=$veri['baslik'];
    $cikti .= "\n<url>\n<loc>http://www.codeboot.com/watch.php?video=$ID</loc>\n<changefreq>daily</changefreq>\n<priority>0.80</priority>\n</url>";
    };

    echo $cikti ."\n</urlset>";

?>

<?php
// db seç
$dbcnx = @mysql_connect("localhost","user","pass");
$dbselect = @mysql_select_db("db_adi");
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET COLLATION_CONNECTION = 'utf8_general_ci'");

// Bilgileri çek.
$query = "SELECT program FROM program_adi";
$result = mysql_query($query) or die('Error: '.mysql_error());

header("content-type:text/xml;charset=utf-8");

	$mapdata .= '<?xml version="1.0" encoding="utf-8"?>' . "\n";
	$mapdata .= '<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">' . "\n";

while($row = @mysql_fetch_array($result)) {
$adi = $row['tag'];	

 $etiket = htmlspecialchars(stripslashes(trim($etiket)), ENT_QUOTES);

	$mapdata .= '	 <url>' . "\n";
	$mapdata .= '        <loc>http://siten.com/'.$adi.'/</loc>' . "\r\n";
	$mapdata .= '        <priority>1.0</priority>' . "\r\n";
	$mapdata .= '        <changefreq>weekly</changefreq>' . "\r\n";
	$mapdata .= '	</url>' . "\r\n";	

}
$mapdata .= '</urlset>' . "\r\n";

header('Content-type: text/xml');
header('Content-disposition: inline; filename=sitemap.xml');

echo $mapdata;

?>

1414 
Çözümleme hatası

Site Haritanızı okuyamadık. Tanıyamadığımız bir giriş içeriyor olabilir. Yeniden göndermeden önce lütfen Site Haritanızı doğrulayın. 	

Sorun algılandı: 17 Eyl 2009

Error: Table 'yuklepaylas.program_adi' doesn't exist

<?php
// db seç
$dbcnx = @mysql_connect("localhost","user","pass");
$dbselect = @mysql_select_db("db_adi");
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET COLLATION_CONNECTION = 'utf8_general_ci'");
// Bilgileri çek.
$query = "SELECT program FROM program_adi";
$result = mysql_query($query) or die('Error: '.mysql_error());
header("content-type:text/xml;charset=utf-8");
	$mapdata .= '<?xml version="1.0" encoding="utf-8"?>' . "\n";
	$mapdata .= '<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">' . "\n";
while($row = @mysql_fetch_array($result)) {
$adi = $row['tag'];	
 $etiket = htmlspecialchars(stripslashes(trim($etiket)), ENT_QUOTES);
	$mapdata .= '	 <url>' . "\n";
	$mapdata .= '        <loc>http://siten.com/'.$adi.'/</loc>' . "\r\n";
	$mapdata .= '        <priority>1.0</priority>' . "\r\n";
	$mapdata .= '        <changefreq>weekly</changefreq>' . "\r\n";
	$mapdata .= '	</url>' . "\r\n";	
}
$mapdata .= '</urlset>' . "\r\n";
header('Content-type: text/xml');
header('Content-disposition: inline; filename=sitemap.xml');
echo $mapdata;
?>