FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 Empty rows when displaying page. View next topic
View previous topic
Post new topicReply to topic
Author Message
MattSturt



Joined: 13 May 2009
Posts: 2

PostPosted: Wed May 13, 2009 11:04 am Reply with quoteBack to top

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>
View user's profile
MattSturt



Joined: 13 May 2009
Posts: 2

PostPosted: Thu May 14, 2009 2:50 am Reply with quoteBack to top

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
View user's profile
Display posts from previous:      
Post new topicReply to topic


 Jump to:   



View next topic
View previous topic


Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme