View Single Post
Old 2005-07-13, 07:59 AM   #1
ynuahayt
My wife is not a doobie to be passed around! On our wedding day I promised to bogart her for life!
 
ynuahayt's Avatar
 
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

?>
I hope someone is able to come up with a solution! If you need more info please do tell me and thank you very much
__________________
Free Blog/Free Site Traffic @ yLovesPorn.com
ynuahayt is offline   Reply With Quote