Completely insane

[james_kirk]

Please someone point me in the right direction before I end up in the boob tube!

I'm trying to use xml to to update a mysql database. My problem is that I want to generate the xml from my current mysql database.

The idea is :

Pull data from database.

display using xml .

alter data .

update table using xml.

I truly despise all things xml but have no choice but to do as I am told.

does anyone know a good source for XML used with php and mysql or shall I shoot myself now and get it over with?

Thanks in anticipation.

[swr]

If you can, try to use XML RPC. This assumes that XML is being used so that other systems can communicate with your system. If that is the case, an XML RPC library will take care of the nitty gritty for you. You just write PHP code normally and make it available to the XML RPC stuff, which takes care of the XML part. There are several XML RPC options to choose from on PHP. Start at the [man]xml rpc[/man] manual page for PHP and read the comments.

[Edit]
I should add that this requires the other side to speak XML RPC too. Code for XML RPC is widely available so it is a good choice. SOAP is another commonly used XML-based thing.

[james_kirk]

Thanks. I got it by using XSL eventually. I uploaded the XML to the screen formatting it as I went and put a button on the screen that you click to enter the data.

Thanks anyhow. Much apprectaied.

(isnt this the nicest php community you ever saw???)