note 56891 added to function.fwrite

heres a nice function for querying a mysql database and writing the results to an xml file. Props to Mihir Shah for the initial script, i just ammended it to write to XML. could do with some validation <?php //Developed by -==[Mihir Shah]==- during my Project work //Extended by Justen Doherty (phpchap@gmail.com) //www.anotherwebdeveloper.com //to create connection to database $connection = mysql_connect("localhost","root", "") or die ("could not connect to database"); //to select the database here test is the sample database come with mysql $db = mysql_select_db("test",$connection) or die ("Couldn't select database."); $rs = mysql_query("SELECT * FROM test",$connection) or die ("invalid query"); //count the no. of columns in the table $fcount = mysql_num_fields($rs); //start the file name $filename = 'test.xml'; function writeXML($rs, $fcount,$filename) { //open xml file for writing $handle = fopen($filename,'w+'); //write header to xml file fwrite($handle, header("Content-type: text/xml")); //you can choose any name for the root element fwrite($handle, "<result>"); //get the db result elements while($row = mysql_fetch_array( $rs ) ) { //write tablerow element fwrite($handle, "<tablerow>"); //loop out the elements in the db for($i=0; $i< $fcount; $i++) { //Get the name of the specified field in a result $tag = mysql_field_name( $rs, $i ); //write element fieldname, value, close element fwrite($handle, "<$tag>". $row[$i]. "</$tag>"); } //close the tablerow element fwrite($handle, "</tablerow>"); } //close the root element fwrite($handle, "</result>"); } //call the function with query result, row count and xml filename writeXML($rs, $fcount, $filename); ?> ---- Manual Page -- http://www.php.net/manual/en/function.fwrite.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+56891 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+56891&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+56891&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+56891&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+56891&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+56891&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+56891&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+56891&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+56891&report=yes Search -- http://master.php.net/manage/user-notes.php