# mysql\_xml\_php

**URL:** <https://forum.kirupa.com/t/mysql-xml-php/318986>\
**Category:** programming\
**Created:** [February 5, 2011, 1:55pm UTC](https://forum.kirupa.com/t/mysql-xml-php/318986 "2011-02-05T13:55:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![verbi](https://avatars.discourse-cdn.com/v4/letter/v/e0b2c6/32.png) [@verbi](https://forum.kirupa.com/u/verbi)\
**Post date:** [February 5, 2011, 1:55pm UTC](https://forum.kirupa.com/t/mysql-xml-php/318986/1 "2011-02-05T13:55:24Z")

</div>

i have table:

```auto

    Date text
09/03/2003 a999999    
09/03/2003 b999999     
10/03/2003 a101010
11/03/2003 a111111

```

php code:

```auto

<?php
header("Content-type: text/xml");
$host = "localhost";
$user = "root";
$pass = "";
$database = "test";

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");
mysql_select_db($database, $linkID) or die("Could not find database.");

$query = "SELECT * FROM blog ORDER BY date DESC";
$resultID = mysql_query($query, $linkID) or die("Data not found.");

$xml_output = "<?xml version=\"1.0\"?>
";
$xml_output .= "<entries>
";

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
    $row = mysql_fetch_assoc($resultID);
    $xml_output .= "	<entry>
";
    $xml_output .= " <date>" . $row['date'] . "</date>
";
        // Escaping illegal characters
        $row['text'] = str_replace("&", "&", $row['text']);
        $row['text'] = str_replace("<", "<", $row['text']);
        $row['text'] = str_replace(">", "&gt;", $row['text']);
        $row['text'] = str_replace("\"", "&quot;", $row['text']);
    $xml_output .= " <text>" . $row['text'] . "</text>
";
    $xml_output .= "	</entry>
";
}
$xml_output .= "</entries>";
echo $xml_output;
?>

```

output:

```auto

<entries>
    <entry>
        <date>11/03/2003</date>
        <text>a111111</text>
    </entry>
    <entry>
        <date>10/03/2003</date>
        <text>a101010</text>
    </entry>
    <entry>
        <date>09/03/2003</date>
        <text>b999999</text>
    </entry>
    <entry>
        <date>09/03/2003</date>
        <text>a999999</text>
    </entry>
</entries>

```

i want output like:

```auto

        <date label='11/03/2003'>
                 <text label='a111111' />
        </date>
        <date label='10/03/2003'>
                 <text label='a101010' />
        </date>
        <date label='09/03/2003'>
                 <text label='a999999' />
                 <text label='b999999' />
        </date>

```

output group by date

```auto

<date label='09/03/2003'>
                     <text label='a999999' />
                     <text label='b999999' />
  </date>

```

how php code for case above?