Skip to main content
Participant
January 15, 2009
Question

RSS php code

  • January 15, 2009
  • 1 reply
  • 753 views
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.
This topic has been closed for replies.

1 reply

Inspiring
January 16, 2009
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:
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid=12&catid=263&entercat=y
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
| http://blog.extensioneering.com/
| WebAssist Extensioneer
| Adobe Community Expert