XML : How can I show all data from mysql to xml?

I would like to get all data from mysql to xml by using PHP, but I tried many times that cannot show all data successfully.

      $scode = mysql_query("SELECT * FROM table WHERE code = '$code'") or die(mysql_error());      $alldata = mysql_query("SELECT * FROM table") or die(mysql_error());      $row_scode = mysql_fetch_assoc($scode);      //$row_alldata = mysql_fetch_assoc($alldata);        $xml = '';      $xml = '<?xml version = "1.0" encoding="UTF-8"?>';      $xml .= '<resource>';  while($row_alldata = mysql_fetch_assoc($alldata)){      $xml .= '<data code = "'.$row_scode['code'].'">';      $xml .= '<name>'.$row_alldata['ename'].'</name>';      $xml .= '</data>';      }      $xml .= '</resource>';        header("Content-Type:text/xml");      echo $xml;