sql2rss v1.x Instructions
1) Unzip the contents of the sql2rss.zip
file, and copy the extracted files to a folder
on your webserver. The folder should be accessible
from the Internet, like your regular webpages.
In fact, the destination folder could be the
same folder that you keep your webpages in.
2) In your browser, enter the full
URL to the location of the sql2rss files,
and run the install module (rss2sql_install.php).
This will bring up a page for the creation
of the parameters needed to access your database.
You will need the configuration file name
later, you can keep the default of "sql2rss_DBconfig.inc.php".
3) In your browser, enter the full
URL to the location of the sql2rss file, and
use 'buildConfig' for a parameter. Example:
This will bring up the configuration screen
4) On the configuration screen, enter
the names of the two template files and a
valid SQL query
5) Hit the 'Generate configuration
data' button at the bottom of the screen.
6) The screen will refresh and display
the contents of a new configuration file in
your browser. You now need to highlight that
data, and copy it to an editor on your local
computer (like notepad).
7) Save the new configuration file
locally, being sure to use .php for the extension.
8) Upload the configuration file, and
put it into the same folder as your sql2rss.php
9) Test sql2rss by entering its URL
into your browser, and including your new
config file as a parameter. Example: http://www.feedforall.com/sql2rss.php?CONFIGFILE=mynewconfig.php
The channel tempalte file must be a valid
RSS 2.0 feed with only the level
taga, without and
- 's. It will be copied
without doing any subsitutions, with a
and set to the durrent time.
The item template must contain a single valid
- . Any text between a pair of
"~~~" will be subistuted with the contents
of the database field of that name, if any.
There is one special tag "~~~RSSDATE(fieldname)~~~"
which will take the contents of the database
"fieldname", which must be a date, and convert
it to a valid RFC 822 date format needed by