<?php  
##################################################################
##                    re-Autor Vipmaster                        ##
##                email vipmaster@ewdesign.com.br               ##
##  Copyright VIPMASTER, todos os direitos reservados ao autor. ##
##################################################################

//para a sa�da
header("Content-type: text/xml"); 

//to create connection to database 
$connection = mysql_connect("127.0.0.1","username", "password") 
or die ("could not connect to database"); 

//para criar a conex�o � base de dados 
$db = mysql_select_db("test",$connection) 
or die ("Couldn't select database."); 

$rs = mysql_query("select * from tablename",$connection) 
or die ("invalid query"); 

//conte o n� das colunas na tabela 
$fcount = mysql_num_fields($rs); 

//voc� pode escolher todo o nome para o Tag come�ando 
echo ("<result>"); 
while($row = mysql_fetch_array( $rs ) ) 
{ 
echo ("<tablerow>"); 
for($i=0; $i< $fcount; $i++) 
{ 
$tag = mysql_field_name( $rs, $i ); 
echo ("<$tag>". $row[$i]. "</$tag>"); 
} 
echo ("</tablerow>"); 
} 
echo ("</result>"); 
?>