more rss

[jus]

I've got my rss feed to validate now, through using CDATA tags to surround all the parts using any html. I've got my last 7 entries on the feed. I'd like the newest of the 7 to be at the top. At the moment, it's the oldest.

I don't have any experience with SQL, so if anyone can suggest how to put this right.... I think that this is the code concerned...

$query = mysql_query("select id,datetime,headline,body,image from ".$pixelpost_db_prefix."pixelpost where (datetime<='$cdate') order by datetime desc limit 0,7");

		while(list($id,$datetime,$headline,$body,$image) = mysql_fetch_row($query)) {
        $headline = pullout($headline);
        $body = pullout($body);
//        $image = $cfgrow['siteurl']."thumbnails/thumb_$image";
		$image = $cfgrow['siteurl']."images/$image";
        $datetime = strtotime($datetime);
        $datetime = date("r",$datetime);
        $body = stripslashes($body);
        $body = htmlentities($body);
        $body = ereg_replace("\n","<br />",$body);

I tried to change the desc to asc in the query order section, and it just took the first 7 posts I ever made. So, can it pull the same 7 records, but in reverse order?

Thanks for any help!

[jus]

got it worked out - it was the way i had the rss reader configured - stupid or what! that's how new i am to rss though...

if anyone's interested, this is the rss feed that validates and works in firefox and rssreader...

if($_GET['x'] == "rss") {
        $output = "<?xml version=\"1.0\" encoding=\"ISO-8859-15\"?>
        <rss version=\"2.0\">
        <channel>
        <title>".$cfgrow['sitetitle']."</title>
        <link>".$cfgrow['siteurl']."</link>
        <description>".$cfgrow['sitetitle']." photoblog</description>
        <docs>http://blogs.law.harvard.edu/tech/rss</docs>
        <generator>pixelpost</generator>";

        $query = mysql_query("select id,datetime,headline,body,image from ".$pixelpost_db_prefix."pixelpost where (datetime<='$cdate') order by datetime desc limit 0,7");

while(list($id,$datetime,$headline,$body,$image) = mysql_fetch_row($query)) {
        $headline = pullout($headline);
        $body = pullout($body);
//        $image = $cfgrow['siteurl']."thumbnails/thumb_$image";
		$image = $cfgrow['siteurl']."images/$image";
        $datetime = strtotime($datetime);
        $datetime = date("r",$datetime);
        $body = stripslashes($body);
        $body = htmlentities($body);
        $body = ereg_replace("\n","<br />",$body);


        $output .= "
        <item>
                <title><![CDATA[ $headline]]></title>
                <link>".$cfgrow['siteurl']."?showimage=$id</link>
                <description><![CDATA[ <img src=\"$image\" style=\"align:center;\" /><br /> $body ]]></description>
                <pubDate>$datetime</pubDate>
        </item>";
}
        $output .= "
        </channel>
        </rss>";
        header("Content-type:application/rss+xml");
        echo $output;
        exit;
}

it's a slightly editted version of the code shown on other pages, i've just added some CDATA tags around the bits i have html in, and i've got it to feed the full size image, rather than a thumbnail - easily changed, the original is just // marked out

clicking on the rss link still generates a file that browsers want to download, but if you copy the rss link http://mysite.com/blogdir/?x=rss into the newsreader program, it seems to work just fine. I've noticed that this is the way most of the MT based sites work too. If they produce a browser full of XML, it's reassuring that it's doing something better than a download, bujt it's not. it's the URL for the feed that i just mentioned that the readers need.

sorry it's lengthy, but there have been a few posts about this, so I hope it's some use to someone...

[ESN]

Remember to add the <lastBuildDate> TAG to make it even better.

check out my post on http://www.pixelpost.org/forum/viewtopic.php?t=293

[jus]

thanks ESN - the code that you put in that thread is where 99.5% of the above came from - nice one.

I shouldn't have started a new thread on this really, can a mod stick these posts onto a common RSS thread?