NewsDesk

[michael_s]

ok its a bit crude but I have now added the database which will give a working RSS list to build on.

include("includes/application_top.php");
header("Content-Type: text/xml");

$gmtdiff = date("O", time());
$gmtstr = substr($gmtdiff, 0, 3) . ":" . substr($gmtdiff, 3, 9);
$now = date("m-d-Y H:i:s", time());
$now = $now . $gmtstr;

echo "n";
echo "n";
echo "n";
echo "RSS Newsfeedsn";
echo "http://www.yourdomain.com/n";
echo "descriptionn";
echo "".$now."nn";
echo "hourlyn";
echo "1n";
echo "".$now."nn";


$result = mysql_query("SELECT * FROM newsdesk_description");
while ( $row = mysql_fetch_array($result) ) {
$ndid=$row["newsdesk_id"];
$ndlanguageid=$row["language_id"];
$ndarticlename=$row["newsdesk_article_name"];
$ndarticledescription=$row["newsdesk_article_description"];
$ndshorttext=$row["newsdesk_article_shorttext"];
$ndarticleurl=$row["newsdesk_article_url"];
$ndarticlurlename=$row["newsdesk_article_url_name"];
$ndarticleviewed=$row["newsdesk_article_viewed"];
$ndimagetext=$row["newsdesk_image_text"];
$ndimagetexttwo=$row["newsdesk_image_text_two"];
$ndimagetextthree=$row["newsdesk_image_text_three"];


echo "n";
echo "".$ndarticlename."n";
echo "http://www.yourdomain.com/newsdesk_info.php?newsdesk_id=$ndidn";
echo "$ndshorttextn";
echo "sales@yourdomain.comn";
echo "".$ndshorttext."n";
echo "".$ndadded."n";
echo "Posted byn";
echo "nn";

}

echo " n";
echo "n";




More...