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

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

//to create connection to database
$connection = mysql_connect("localhost","usuario","senha")
or die ("could not connect to database");

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

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

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

//charset para o indioma portugu�s
echo ("<".chr(077)."xml version='1.0' encoding='ISO-8859-1'".chr(077).">");

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