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/
