# Newbie having problems~

**URL:** <https://forum.kirupa.com/t/newbie-having-problems/310294>\
**Category:** programming\
**Created:** [June 7, 2010, 3:17am UTC](https://forum.kirupa.com/t/newbie-having-problems/310294 "2010-06-07T03:17:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![siongjk](https://avatars.discourse-cdn.com/v4/letter/s/73ab20/32.png) [@siongjk](https://forum.kirupa.com/u/siongjk)\
**Post date:** [June 7, 2010, 3:17am UTC](https://forum.kirupa.com/t/newbie-having-problems/310294/1 "2010-06-07T03:17:04Z")

</div>

i have just read the tutorial of [FONT=Verdana][SIZE=4][COLOR=#003366]\*\*  
Output mySQL data\*\* as XML with PHP[/COLOR][/SIZE][/FONT][FONT=Arial][SIZE=1][COLOR=#808080] [/COLOR][/SIZE][/FONT] [FONT=Verdana][SIZE=1][COLOR=#808080]by Jubba  
[/COLOR][/SIZE][/FONT]  
then i face a problem where i need to produce xml file  
which is look like this:  
[COLOR=DarkGreen]\<?xml version=“1.0”?\>  
[/COLOR][COLOR=DarkGreen]\<gallery\>  
\<category name=“category01”\>  
\<image\>  
\<date\>15.03.08\</date\>  
\<title\>image01 title\</title\>  
\<img\>pic01.jpg\</img\>  
\</image\>  
\<image\>  
\<date\>15.03.08\</date\>  
\<title\>image02 title\</title\>  
\<img\>pic02.jpg\</img\>  
\</image\>  
\</category \>

\<category name=“category02”\>  
\<image\>  
\<date\>15.03.08\</date\>  
\<title\>image03 title\</title\>  
\<img\>pic03.jpg\</img\>  
\</image\>  
\<image\>  
\<date\>15.03.08\</date\>  
\<title\>image04 title\</title\>  
\<img\>pic04.jpg\</img\>  
\</image\>  
\</category \>

\</gallery\>[/COLOR] [FONT=Verdana][SIZE=4][COLOR=#003366][/COLOR][/SIZE][/FONT]  
how does the Mysql table should look like and how to create this kind of look using php?

Help me out please~~!