[PHP] PHP/MYSQL/XML Conversion

2007-07-23 Thread Kelvin Park
I'm trying to convert joined multiple database table to one xml file. Is it more efficient to initially, join multiple (more that 4 tables) together to produce XML file, or convert every table in to XML file and use those XML files to relate data? -- PHP General Mailing List

Re: [PHP] PHP/MYSQL/XML Conversion

2007-07-23 Thread Nathan Nobbe
certainly it is better to use the database, as it is designed for such a purpose. -nathan On 7/23/07, Kelvin Park [EMAIL PROTECTED] wrote: I'm trying to convert joined multiple database table to one xml file. Is it more efficient to initially, join multiple (more that 4 tables) together to

Re: [PHP] PHP/MYSQL/XML Conversion

2007-07-23 Thread Chris
Kelvin Park wrote: I'm trying to convert joined multiple database table to one xml file. Is it more efficient to initially, join multiple (more that 4 tables) together to produce XML file, or convert every table in to XML file and use those XML files to relate data? I'd make the database do

Re: [PHP] PHP/MySQL/XML

2002-04-01 Thread Erik Price
On Monday, April 1, 2002, at 02:33 PM, Jay Fitzgerald wrote: Can this be done and am I going about it the right way? First, it's a bad idea to cross-post between mailing lists, even if they seem like related topics. Second, what is it you're trying to do? Or what does your application

Re: [PHP] PHP/MySQL/XML

2002-04-01 Thread Thalis A. Kalfigopoulos
On Mon, 1 Apr 2002, Jay Fitzgerald wrote: I have created a database called friends with four columns: Name / Address / City / State I also made an XML file to coincide with those variables: test contacts friends nameFriend 1/name

Re: [PHP] PHP/MySQL/XML

2002-04-01 Thread Erik Price
On Monday, April 1, 2002, at 02:33 PM, Jay Fitzgerald wrote: Can this be done and am I going about it the right way? Are you familiar with something called partial decomposition? I'm not sure where it came from, but Google suggests that it may have been conceived by Daniel Appelquist, the

Re: [PHP] PHP/MySQL/XML

2002-04-01 Thread Erik Price
Shoot, kind of an important error I made in the code I gave you earlier -- the closing quote for $xml_document should be a single-quote, not a double-quote as I wrote. Sorry, Erik On Monday, April 1, 2002, at 04:26 PM, Erik Price wrote: Still, you want some advice? First, your SQL code

[PHP] PHP/MySQL/XML

2002-04-01 Thread Jay Fitzgerald
I have created a database called friends with four columns: Name / Address / City / State I also made an XML file to coincide with those variables: test contacts friends nameFriend 1/name address999 Foo Avenue/address