php variables do not read on rss

[electricocean]

Hi I am having problems with php varibles in the rss.

My code:

<?php
echo "<?xml version=\"1.0\"?><rss version=\"2.0\"><channel><title>example
Jokes</title><link>http://mysite.com/</link><description>Stuff that makes you laugh.</description><language>en-us</language><webMaster>[e-mail]</webMaster>";//Create xml and rss
include('../mysql_connect.php');//connect
$query = "SELECT * FROM jokes ORDER BY joke_id DESC LIMIT 20";//start querying and do stuff

//if(!$result){
//$error = mysql_error();
//echo "<item><title>Error wahhhh</title><link>http://example.org/</link><description>". $error ."</description></item>";
//}
//alloways outputs error...

while($row = mysql_fetch_assoc($result)){//loops database results
$joke_id = $row['joke_id'];
$genre = $row['genre'];
$title = $row['title'];//<a><b><center><i><li><sub><sup><q>
$joke = $row['joke'];
$joke = str_replace('<', '&lt;', $joke);
$joke = str_replace('>', '&gt;', $joke);
$joke = str_replace('<center>', '', $joke);
$joke = str_replace('</center>', '', $joke);
$rating = $row['rating'];
$bgcolor = $row['bgcolor'];
$link = "http://dkicks.dk.funpic.org/?pageid=includes/jokedisplay.php?jokeid={$joke_id}";
echo "<item><title>". $title ."(". $genre .")</title><link>". $link ."</link><description>". $joke ."</description></item>";
}
echo "</channel></rss>";
?>

For some reason the php vairibles will not output to anyof the lines

whats wrong?

[edited by: jatar_k at 2:21 am (utc) on Sep. 16, 2005]

[edited by: coopster at 12:13 am (utc) on Sep. 27, 2005]
[edit reason] examplified/language [/edit]

[coopster]

I'm guessing either your database connection or your query is incorrect. Also, you should check the number or rows returned to see if they are greater than zero, and continue processing based on that returned logic/value.

Are you getting an error?