FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 No stories appearing in the feed View next topic
View previous topic
Post new topicReply to topic
Author Message
phi



Joined: 06 Jan 2011
Posts: 1

PostPosted: Thu Jan 06, 2011 9:32 am Reply with quoteBack to top

Hope someone can help.

I've installed all the files on my server and they seem to be working fine

http://www.investthamesgateway.com/rss/sql2rss.php

but I am not seeing any stories from my news database table

the table is called news and I want to call these 3 fields
id
title
strap
creation_date

This is my sql quesry

$SQLQuery = "SELECT * FROM news WHERE title LIKE \"%FeedForAll%\" ORDER BY creation_date DESC LIMIT 10";

and my item template XML looks like this

<item>
<title>~~~title~~~</title>
<link>http://www.investthamesgateway.com/thames-gateway-news/news_details.php?id=~~~id~~~</link>
<description>~~~strap~~~</description>
<pubDate>~~~RSSDATE(creation_date)~~~</pubDate>
</item>

Where am I going wrong?

Thanks
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2783

PostPosted: Mon Jan 10, 2011 4:08 pm Reply with quoteBack to top

First thing to try is to simplify your query statement, in case you are overlooking something. Try something like this:

SELECT * FROM news LIMIT 10

See if that gives any different results.

_________________
Create RSS Feeds
Audio Recording and Editing
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