xml connect with MySQL

<?php 

$database = "nameofthedatabase"
$dbconnect = mysql_pconnect(localhost, dbuser, dbpassword);
mysql_select_db($database, $dbconnect);
$query = "select link, headline, description from 'headlines' limit 15";
$result = mysql_query($query, $dbconnect);

while ($line = mysql_fetch_assoc($result))
  {
    $result&#91;&#93; = $line;
  }
$now = date("D, d M Y H:i:s T");

$output = "<?xml version=\"1.0\"?>
        <rss version=\"2.0\">
          <channel>
            <title>Our Demo RSS</title>
            <link>http://wwww.tracypeterson.com/RSS/RSS.php</link>
            <description>A TEST RSS</description>
            <language>en-us</language>
            <pubDate>$now</pubDate>
            <docs>http://someurl.com</docs>
            <managingEditor>yo@youremail.com<managingEditor>
            <webMaster>you@youremail.com</webMaster>
          ";
foreach ($return as $line)
{
  $output .= "<item><title>".htmlentities($line['headline'])."</title>
              <link>".htmlentities($line['link'])."</link>

  <description>".htmlentities(strip_tags($line['description']))."</description>
      </item>";
}
$output .= "</channel></rss>";
echo $output;
?>

<?php
// ヘッダーを出力する
header("Content-type: text/xml;charset=utf-8");
echo '<?xml version="1.0" encoding="UTF-8"?>';

// サイト情報を書き込む
echo '
<rss version="2.0">
<channel>
<title>hogehogeオレオレRSS</title>
<link>http://google.com</link>
<description>Facebookのgraph api, cake php, javascriptなどの記事を更新していきます。</description>
<category>php, graph api, facebook, cakephp</category>
<generator>@DAI199</generator>
<webMaster>@DAI199</webMaster>
';

// 記事の内容を更新
for(ループさせる)
{
echo '
<item>
<title>Test'.$i.'</title>
<link>http://google.com</link>
<description>TestTest</description>
<author>@DAI199</author>
<category>php</category>
</item>
';
}

echo '
</channel>
</rss>
';
?>