<?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>"); ?>