thewood68

its the 4th table that you speak of im not familiar with on how to set up.

ok so lets say i have database that is storing different kinds of writing utencils (pens, markers, crayons, pencils etc...) and these are all user generated. after that they pick what they like using this utencil best for. example: crayons - coloring. pencils -math etc. but then someone else says they really like using pencils for drawing and ten people agree that they like using it for drawing but 100 say they like using it for math. i need to be able to store all the different uses for each item and how many agree with the use for that. whats the best way about doing that?

i havent ever used interacting tables so would there be anything extra other than setting assinging identical field names?

think you could dumb that down for me?

ok so lets say i have database that is storing different kinds of writing utencils (pens, markers, crayons, pencils etc...) and these are all user generated. after that they pick what they like using this utencil best for. example: crayons - coloring. pencils -math etc. but then someone else says they really like using pencils for drawing and ten people agree that they like using it for drawing but 100 say they like using it for math. i need to be able to store all the different uses for each item and how many agree with the use for that. whats the best way about doing that?

should have known, thanks.

ok so basically im populating an array from a mysql field where the text can be the same or be different and then printing it into a selectable html list but i dont want to have 20 repeats if one already exists... what would be the best way to handle this? thanks

you guys are absolutely amazing. thank you so much

that gives me Array ( [PW Gopal] => Rocking Chair [Kenny Chesney] => There Goes My Life [Andy Griggs] => She Thinks She Needs Me [Colbie Caillat] => Bubbly ) i can definently tell its almost there but im not sure how i would go about dynamically printing out Artist PW Gopal Song Rocking Chair

thats definently the right direction... my output for that is. what would i run to filter all the extra out just to get the "PW Gopal"? array(4) { [0]=> object(SimpleXMLElement)#2 (1) { [0]=> string( "PW Gopal" } [1]=> object(SimpleXMLElement)#3 (1) { [0]=> string(13) "Kenny Chesney" } [2]=> object(SimpleXMLElement)#4 (1) { [0]=> string(11) "Andy Griggs" } [3]=> object(SimpleXMLElement)#5 (1) { [0]=> string(14) "Colbie Caillat" } }

im attaching a sample xml file where i need to retrieve information regarding song artist and song name....this is a long list so there are lines 17 and 18: <key>Name</key><string>Rocking Chair</string> <key>Artist</key><string>PW Gopal</string> lines 48 and 49: <key>Name</key><string>There Goes My Life</string> <key>Artist</key><string>Kenny Chesney</string> etc... these lists could potentially contain 1000's of these brackets. all i want from each one of these is Song Rocking Chair Artist PW Gopal Song There Goes My Life Artist Kenny Chesney Thanks [attachment deleted by admin]

nope not exclusive

for compatibilty purposes i've decided to go from using .txt files to using .xml files. again theres so much extra information with the export that i need to get rid of it all and only keep the title of the song and artist name. i attached a sample output .xml file. thanks in advance! [attachment deleted by admin]

is there a way of addressing this encoding problem? the problem is when i try to print $song_data[$i][Artist], in the different encoding that variable is empty.

Ok running into a problem. I got everything running on my laptop but then i went and tested it on a different laptop and it didnt work correctly. I ran an output from my itunes "Music2.txt" and I ran an output on his computer "Music.txt". When looking at the two .txt files side by side I cannot find any differences. Thanks for the help. Output from working "Music2.txt" [1] => Array ( [Name] => Tuesday Night [Artist] => Adam Hood [Composer] => A. Hood [Album] => 6th Street [Grouping] => [Genre] => Rock => 4605952 [Time] => 190 [Disc Number] => [Disc Count] => [Track Number] => 1 [Track Count] => [Year] => 2004 [Date Modified] => 9/19/2006 11:56 PM [Date Added] => 8/23/2006 1:54 AM [bit Rate] => 192 [sample Rate] => 44100 [Volume Adjustment] => [Kind] => MPEG audio file [Equalizer] => [Comments] => [Play Count] => 35 [Last Played] => 10/21/2007 4:51 PM [skip Count] => [Last Skipped] => [My Rating] => [Location ] => C:\Documents and Settings\All Users\Documents\My Music\Sample Music\ah.tuesday.night.192.mp3 ) Output from Non-Working [1] => Array ( [ÿþN a m e ] => T u e s d a y N i g h t [ A r t i s t ] => A d a m H o o d [ C o m p o s e r ] => A . H o o d [ A l b u m ] => 6 t h S t r e e t [ G r o u p i n g ] => [ G e n r e ] => R o c k [ S i z e ] => 4 6 0 5 9 5 2 [ T i m e ] => 1 9 0 [ D i s c N u m b e r ] => [ D i s c C o u n t ] => [ T r a c k N u m b e r ] => 1 [ T r a c k C o u n t ] => [ Y e a r ] => 2 0 0 4 [ D a t e M o d i f i e d ] => 1 2 / 2 3 / 2 0 0 6 6 : 3 7 P M [ D a t e A d d e d ] => 8 / 2 6 / 2 0 0 7 4 : 3 4 P M [ B i t R a t e ] => 1 9 2 [ S a m p l e R a t e ] => 4 4 1 0 0 [ V o l u m e A d j u s t m e n t ] => [ K i n d ] => M P E G a u d i o f i l e [ E q u a l i z e r ] => [ C o m m e n t s ] => [ P l a y C o u n t ] => 2 [ L a s t P l a y e d ] => 1 2 / 1 0 / 2 0 0 7 8 : 0 0 P M [ S k i p C o u n t ] => 3 [ L a s t S k i p p e d ] => 1 / 2 0 / 2 0 0 8 9 : 3 0 P M [ M y R a t i n g ] => [ L o c a t i o n ] => C : \ D o c u m e n t s a n d S e t t i n g s \ A l l U s e r s \ D o c u m e n t s \ M y M u s i c \ S a m p l e M u s i c \ a h . t u e s d a y . n i g h t . 1 9 2 . m p 3 ) [attachment deleted by admin]