 |
|
Author |
Message |
phi
Joined: 06 Jan 2011
Posts: 1
|
Posted:
Thu Jan 06, 2011 9:32 am |
  |
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: 2798
|
Posted:
Mon Jan 10, 2011 4:08 pm |
  |
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 |
|
 |
 |
|
| |