Making a RSS feed - Query Error

I have this code:

<?php
$db_host = "localhost";
$db_user = "blank";
$db_password = "blank";
$db_name = "blank";
 

// parametri del database
$db = mysql_connect($db_host, $db_user, $db_password);
mysql_select_db($db_name, $db)
or die ("Errore nella selezione del database.");

 header('Content-type: text/xml'); ?>

<rss version="2.0">
<channel>
<title>CurrentHumor.com</title>
<description>Funny Videos and Sexy Videos</description>
<link>http://www.currenthumor.com/</link>


<?
$query="SELECT * FROM content WHERE content.id AND content.thumb ORDER BY added DESC LIMIT 0,15 ";
$result = mysql_query($query); 

while($row = mysql_fetch_array($result))

{
echo 
     "	<item> 
        <title>".$row['title']."</title> 
        <link>http://www.currenthumor.com/index.php?out=".$row['id']."</link> 
	<image>http://www.currenthumor.com/thumbs/".$row['thumb']."</image>
</item>";
 }  
?>
</channel>
</rss>

PHP:

I get this error here: http://www.currenthumor.com/rss.php


I am a complete beginner to this, so help me out and explain well.

Thanks.

Regards,
Kyle

 

I think your query is coming up empty. Check that $result is not empty before the while loop.

 

Thanks, your input lead me to finding the problem.

Later,
Kyle

 

cool. nice tip