RSS Feed generating: php & MySQL problems [Archive]

ynuahayt

2005-07-13, 08:59 AM

Ok I'm using this RSS Feed Generator (http://www.2rss.com/software.php#rss20) 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!):

<?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 :)