Feed not working

[tutu saint]

Hello,

I created a php feed page for my site and needs the page to show rescent jobs which can be clicked to access the particular link.

This is what i have and it is not working.
Please help

<?php  header('Content-type: text/xml'); ?>
     
	<rss version="2.0">
	<channel>
	<title>xcvxcv</title>
	<description>xcvxvxcv</description>
	<link>http://www.!!!!!.com/</link>
<?php	

  
    $host = "localhost";
    $user = "root";
    $password = "root";
    $db = "job";
    $numOfJobs=0; 
	//$start-index=$_REQUEST['start-index'];
	//$max-results=$_REQUEST['max-results'];
	$conn = mysql_connect($host,$user,$password)or die("Problems :".mysql_error());
    $dbselect = mysql_select_db($db,$conn) or die("Error in selecting DB: ".mysql_error());

	 $query="select * from jobs order by job_id DESC LIMIT 50";


 while($result = mysql_fetch_array($query)){
?> 
     <item> 
        <title> <?=htmlentities(strip_tags($result['job_title'])); ?></title> 
                <link>http://jobsearchng.org/job.php?p=<?=$result['job_id'];?></link> 
        </item>    
<? } ?>  


   </channel>
	</rss>

[Rabbit]

Just saying it's not working doesn't help. You need to describe what's not working. Are you getting error messages? What are they? Is it not doing what you want? What is it doing instead?