Dear Plumber, It seems that you have gravely misunderstood my question. See Mr Castagnetto's excellent answer and you might grasp what I was looking for. However thanks for all the links! Best regards Fredrik -----Opprinnelig melding----- Fra: plumber [mailto:almisr@yahoo.fr] Sendt: den 15 januari 2003 10:31 Til: php-objects@yahoogroups.com Emne: Re: [php-objects] XML AND PHP -> Database to XML? ######################################################################## please learn xml first it doesn't work like this a xml file is just a multi array node[0][1][6] ######################################################################## ####################### On mercredi, jan 15, 2003, at 09:52 Europe/Paris, Fredrik Davidsson wrote: > I want to insert the following data into a database. > > <xml> > <value1>56</value1> > <value2>1222</value2> > <value3>78.5</value3> > </xml> > > This is easy and the SQL command would look like this: > INSERT INTO readings(value1, value2, value3) VALUES("56", "1222", > "78.5") > > However, if the data looks like this what is your suggestion on > database > design? > <xml> > <value1>56</value1> > <value2>1222</value2> > <value2>LOOK</value2> > <value3>78.5</value3> > </xml> > > I want to put all data in the same record, but how should I manage the > duplication of <value2> in a nice way? > > Best regards Fredrik Davidsson > > > ------------------------ Yahoo! Groups Sponsor > ---------------------~--> > Turn flat surfaces into speakers with the Soundbug. > http://us.click.yahoo.com/QWAVSC/onCFAA/sXBHAA/saFolB/TM > --------------------------------------------------------------------- > ~-> > > Look here for Free PHP Classes of objects: > http://phpclasses.UpperDesign.com/ > To unsubscribe from this group, send an email to: > php-objects-unsubscribe@egroups.com > > > > Your use of Yahoo! Groups is subject to > http://docs.yahoo.com/info/terms/ > ___________________________________________________________ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com Look here for Free PHP Classes of objects: http://phpclasses.UpperDesign.com/ To unsubscribe from this group, send an email to: php-objects-unsubscribe@egroups.com Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ ------------------------ Yahoo! Groups Sponsor ---------------------~--> Flexible Keyboard is the ideal accessory for PDA users that are on the move. http://us.click.yahoo.com/dCBVZC/WnCFAA/sXBHAA/saFolB/TM ---------------------------------------------------------------------~-> Look here for Free PHP Classes of objects: http://phpclasses.UpperDesign.com/ To unsubscribe from this group, send an email to: php-objects-unsubscribe@egroups.com Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
