[ragrim]

Hi,

for the last few hours ive been trying to make a php script that will grab some data from my mysql database and save it to a xml file, now that much i can do based on some info i have found on various sites, but saving it in the format i need is the problem.

so what i have is 2 fields in my table, time and cpu

the format i need them to save in is

<graph caption='Monthly Unit Sales' xAxisName='Month' yAxisName='Units' showNames='1' decimalPrecision='0' formatNumberScale='0'>
<set name='timevalue' value='cpuvalue' color='AFD8F8' />
</graph>

if anyone could help me with a script that can do this id be very appreciative. thanks.