|
2005-07-13, 07:59 AM | #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 |
2005-07-14, 09:03 AM | #2 |
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
|
Issue has been resolved - move along nothing to see here!
__________________
Free Blog/Free Site Traffic @ yLovesPorn.com |
2005-07-16, 06:11 PM | #3 |
Just because I don't care doesn't mean I don't understand!
Join Date: May 2005
Posts: 96
|
awww ;-( I was getting all excited about being able to spot the bug
|
|
|