MySQL to RSS using PHP

[i7Grendel]

[Guest xaav]

You forgot to put a closing quote before the parentheses.

 

$ndata = dbquery('SELECT `blog_id`, `blog_subject`, `blog_text`, `blog_date`, `blog_writer` FROM `'.$db_prefix.'ti_blog_system` WHERE `blog_writer`=1 ORDER BY `blog_date` DESC LIMIT 5');

[i7Grendel]

Thank you, the RSS feed works (unbelievable that it's often so simple). But now I have another problem. My description looks like this:

 

This is an integrated blog system I'm trying to replace the News section, because the News section doesn't limit the amount of displayed items which would result in a horrible amount of items over time.

 

I changed one of the lines to fix one error, so now it looks like this

 

    $data.="        <description>".stripslashes(htmlspecialchars($text))."</description>\n";

 

Can somebody help me to display the apostrophes properly?

[Guest xaav]

You will need to put it in those <![CDATA[ tags, because the contents of the description may not be proper XML.

[i7Grendel]

Those CDATA tags were the error I fixed. But actually, I only saw that error when I viewed the feed in a browser, not in a RSS Reader. I restored the original line, and after some final tweaking my Blog Feed is finally ready. Sweet. And thanks again!