|
![]() |
#1 |
My wife is not a doobie to be passed around! On our wedding day I promised to bogart her for life!
Join Date: Jan 2005
Posts: 274
|
RSS Feed generating: php & MySQL problems
Ok I'm using this RSS Feed Generator to make a feed that can tell people when there's a new site in for example an Amateur Porn category. It's running through php and MySQL and I suck at both
![]() Here's the feed so you can see the error message: http://ylovesporn.com/rss/rss20.php Here's what I have (Database information is edited out!): Code:
<?php /***************************************************** RSS20.php - RSS generator by Ovi Crisan @ www.2RSS.com All rights reserved - V1.0 - Also, available for ASP This script is distributed as freeware. You can change it upon your needs but have to keep its copyright info More scripts [PHP & ASP] and RSS directory on our site ******************************************************/ $rss_server="xxx"; // MySQL server $rss_db="xxx"; // MySQL database $rss_user="xxx"; // MySQL user $rss_pass="xxx"; // MySQL password // prefix for links, concatenated with their id $item_link="http://ylovesporn.com/page.php?id="; $channel_copyright="ylovesporn.com"; $channel_editor="ynuahayt@ylovesporn.com"; //Format: email_address OR email_address (name) $channel_webmaster="ynuahayt@ylovesporn.com"; //Format: email_address OR email_address (name) $image_title=""; // channel image or site logo $image_url=""; // image URL [jpg, gif] $image_link=""; $image_width=88; $image_height=31; $encoding="iso-8859-1"; include_once("rss20inc.php"); /************************************************** Purpose: add all channels available with RSS script Format for add_channel(): add_channel( Channel_Title, Channel_Link, Channel_Description, SQL_Command, RSS_ID ) Parameters: - Channel_Title - Channel_Link - URL of the site - Channel_Description - SQL_Command - SQL command used to get info SQL SELECT fields: Title,Link,Description,Date,Author - RSS_ID - unique ID of the RSS feed - leave empty for a single feed ***************************************************/ add_channel( "ynuhayt Loves Free Porn", "http://ylovesporn.com/", "Last added links at http://ylovesporn.com/", "SELECT items.name AS Title, items.url AS Link, items.descr AS Description, FROM_UNIXTIME(items.ndate) AS Date, FROM items INNER JOIN items ON WHERE items.ref_id_categories='2' ORDER BY items.ndate DESC LIMIT 10", ""); header ("Content-type: text/xml"); rss(); // create RSS content ?> ![]()
__________________
Free Blog/Free Site Traffic @ yLovesPorn.com |
![]() |
![]() |
|
|