 |
|
| Author |
Message |
MattSturt
Joined: 13 May 2009
Posts: 2
|
 Posted:
Wed May 13, 2009 11:04 am |
  |
Hi,
I'm having problems getting output using SQL2RSS, here is the debug. It all works except I get ten emtpy entries. Do I need to change the title, link, date vars somewhere ?
Thanks
SUCCESS: mysql_connect(localhost, ********, ********)
SUCCESS: mysql_select_db(testing)
SUCCESS: FeedForAll_database_query($config, SELECT * FROM latest_news ORDER BY id DESC LIMIT 10)
<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
<channel>
<title>sql2rss.php Sample Template</title>
<description>A sample RSS feed template for sql2rss.php, http://www.FeedForAll.com/, by NotePage, Inc.</description>
<link>http://www.FeedForAll.com/</link>
<docs>http://blogs.law.harvard.edu/tech/rss</docs>
<language>en-us</language>
<generator>FeedForAll-scripts (sql2rss.php), http://www.FeedForAll.com/, Copyright 2006-2007, NotePage, Inc.</generator>
<lastBuildDate>Wed, 13 May 2009 16:53:38 +0100</lastBuildDate>
<pubDate>Wed, 13 May 2009 16:53:38 +0100</pubDate>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
<item>
<title></title>
<link></link>
<description></description>
<pubDate></pubDate>
</item>
</channel>
</rss> |
|
|
 |
|
MattSturt
Joined: 13 May 2009
Posts: 2
|
| Posted:
Thu May 14, 2009 2:50 am |
|
Hi,
Sorted this out myself, I had not changed the template file to include the DB row names. All working now, great tool, thank you.
Matt |
|
|
|
|
|
|
| |
