######################################################################## 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 ------------------------ 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/