SQL2RSS v3.x InstructionsContents  Introduction  Installation  Channel Template  Item Tempalte  UsageIntroduction:=============SQL2RSS allows easy creation of RSS 2.0 feeds from your existing database or one created by RSS2SQL.  SQL2RSS has 2 modules.  sql2rss_install.php will create the database configuration file.  sql2rss.php is used to build configuration files and to create the feeds.Installation:=============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).Example: http://www.feedforall.com/sql2rss_install.phpThis 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: http://www.feedforall.com/sql2rss.php?buildConfig This will bring up the configuration screen for sql2rss4) On the configuration screen, enter the names of the two template files and a valid SQL query5) 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 file9) 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.phpChannel Template:=================The channel tempalte file must be a valid RSS 2.0 feed with only the <channel> level taga, without and <item>'s.  It will be copied without doing any subsitutions, with a <pubData> and <lastBuildDate> set to the current time.Item Tempalte:==============The item template must contain a single valid RSS 2.0 <item>.  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 RSS 2.0.Usage:------After creating your new configuration, copy the configuration file from the sql2rss.php?buildConfig page to a file ending in .php on your server.  You can specify this file as your feed.  If you name the file "myfeed.php" you could access the created feed in two ways, http://www.your-web-server.com/sql2rss.php?CONFIGFILE=myfeed.php , which will work but is messy.  You can also produce the exact same results with http://www.your-web-server.com/myfeed.php .  Using this shortened version makes much cleaner URLs for your users or as the input to other FeedForAll scripts.Copyright 2006-2007 NotePage, Inc. All rights reserved$Id: sql2rss-docs.txt,v 3.0 2007/04/16 14:23:05 housley Exp $