RSS php code

[jh369057]

Can anyone see what is wrong with the attached code. I have a table named
'page' with the field 'Number' 'Title' and 'ImageLink' within it. I can get
the simple rss feed to show up with my website information but it wont echo the
items within the database.

<?php
header('Content-type: text/xml');
echo '<?xml version=\'1.0\' encoding=\'UTF-8\'?>';
// Set RSS version.
echo '
<rss version=\'2.0\'> ';
// Start the XML.
echo '
<channel>
<title>MyWebsite Blog Headlines</title>
<description>New Blog Entries</description>
<link>http://www.mywebsite.com/</link>
<image>
<title>mywebsite</title>
<width>142</width>
<height>18</height>
<link>http://www.mywebsite.com</link>
<url>http://www.mywebsite.com/Images/smallbanner</url>
</image>';
require_once('Connections/MyConnection.php');
// Query database and select the last 10 entries.
$data = mysql_query('SELECT * FROM page ORDER BY Number DESC LIMIT 10');
while($row = mysql_fetch_array($data))
{
// Convert database images data into actual image link.
$row[ImageLink] = str_replace('images/', 'http://www.mywebsite.com/images/',
$row[ImageLink]);
// Continue with the 10 items to be included in the <item> section of the XML.
echo '
<item>
<link>http://www.mywebsite.com/detailed.php?recordID='.$row[Number].'</link>
<guid
isPermaLink=\?true\?>http://www.mywebsite.com/detailed.php?recordID='.$row[Numbe
r].'</guid>
<title>'.$row[Title].'</title>
<description><![CDATA['.$row[ImageLink].']]></description>

<comments>http://www.mywebsite.com/detailed.php?recordID='.$row[Entry].'#Comment
s</comments>
</item>';
}
// substr can limit the number of characters. First number is starting point
while the second number is number of characters.
// otherwise just use $row[Intro].
// <guid> is an optional sub-element of <item> but recommended if you don?t
want to receive a warning when validating your RSS.
echo '
</channel>
</rss>';
?>

[danilocelic AdobeCommunityExpert]

jh369057 wrote:

> Can anyone see what is wrong with the attached code. I have a table named
> 'page' with the field 'Number' 'Title' and 'ImageLink' within it. I can get
> the simple rss feed to show up with my website information but it wont echo the
> items within the database.

If your code does not output the content from the database, then either you are attempting to output it improperly, or the data is not getting accessed from the database properly and isn't present to output.

In a quick look, there are several potential problems:
Your mysql_query doesn't specify the database connection, it's possible that your connection include specifies it, but as you didn't show the code it's hard to tell.

When you output the values for from your row of data, you do not have them quoted, as in:
$row[Number]
It should be something like:
$row["Number"]

If that doesn't help, or you still have problems, you should ask your question over in the Dreamweaver Application Dev group:
[url]http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid=12&catid=263&entercat=y[/url]
And post a link to your page, as it may help in determining what is getting output and what should be output. Also, if you are getting any errors, you should post what those errors are and on which lines. When working with XML files, it may be harder to determine if there is an error, especially with RSS XML, as some browsers may be hiding the errors generated. It may be good to comment out the content type header, and only uncomment it when you have a fully working page.


--
Danilo Celic
| [url]http://blog.extensioneering.com/[/url]
| WebAssist Extensioneer
| Adobe Community Expert