Query Troubles

programming
1

We’re creating a MySQL Query that gets data from a table and creates an XML file with it, Currently we get an error…

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/davidwin/public_html/earlangelos/Meg Richardson - Earl Angelos/admin/gallery/xmlspawner.php on line 8

This is my code.

<?php 
  
$rs = @mysql_select_db( "younes2_lotus" );
       
       $sql="select * from item";
       
       $result = mysql_query($rs, $sql);
       
$file= fopen("images.xml", "w"); 
  
$_xml ="<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"yes\"?>
"; 
  
$_xml .="<images>
"; 
  
while ($row = @mysql_fetch_array($result)) { 
  
$_xml .="	<pic>
"; 
   $_xml .="		<image>http://www.designsbyrema.com/earlangelos/Meg Richardson - Earl Angelos/admin/gallery/pics/big/".$row["id"].".jpg</image>
";             
$_xml .="	</pic>
"; 
} 
  
$_xml .="</images>"; 
  
fwrite($file, $_xml); 
  
fclose($file); 
?>