Inserting MySQL data into existing xml file

[danbm]

Hi,
I have an xml file with a value I need to be read from a MySQL database. I'm not sure of the best way to include this value into the XML.

The database table only has 1 entry, 2 fields, ID and target, it's target I want to include.

The line in the XML file is:

<Gauge2RadialNeedle id="needle2" value="270" stroke="#000000" strokeWidth="1"

I need to replace the value - 270 - with the data from the database.

Hope someone can help, it's driving me nuts and Great Uncle Google has been useless this time!

Dan

[Charles]

Great Uncle Google has been useless this time!

That's because there are as many ways to accomplish this as there are tools. What tools do you have available? PHP? Perl? Are you on a Windows box?

[danbm]

php on a linux box.

[Charles]

Then you'll need to parse the XML into a tree, read the DB and modify the tree accordingly. The folks over on the PHP forum will be better able to help you.