in this order http://www.w3c.org/XML/ http://www.w3c.org/TR/xmlbase/ http://www.w3c.org/Encryption/2001/ http://www.w3c.org/2001/XKMS/ http://www.w3c.org/XML/Query http://www.w3c.org/XML/Schema http://www.w3c.org/Signature/ http://www.xml.com/ http://sourceforge.net/projects/phpautodoc/ http://phpxmlclasses.sourceforge.net/ On mercredi, jan 15, 2003, at 10:31 Europe/Paris, plumber wrote: > ####################################################################### > # > 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/ > ___________________________________________________________ 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/
