No stories appearing in the feed

phi · Joined: 06 Jan 2011 Posts: 1

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

Tech Support · Joined: 27 Aug 2004 Posts: 2793

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.