Re: Pictures and sound in MySQL and access via PHP

thank you, If i understand the best way would be to place the MP3's in a seperate directory and giving each MP3's a unique id? In the database every record has already a unique idea. If i name my mp3 something like this: record ID=10, name MP3 = MP3_10.mp3. I already have about 200 little MP3's with the prononciation of the words in a dictionary. Is there a way to automate this task? So changing the original name of the MP3 ex.. "komen.mp3" in "MP3_10.mp3"? Lallous <phplist@lgwm.org> schreef in berichtnieuws 20020810070615.23732.qmail@pb1.pair.com... > Personally I wouldn't store BIG files (like .mp3) into the database. > > If you insist checkout the mysql LOAD_FILE() > > Elias > > "Danny" <phpdummy@belgacom.net> wrote in message > news:20020809170712.95046.qmail@pb1.pair.com... > > hi, > > > > I already posted this message but the time on my computer was wrong (26/07 > > so i post it again). > > > > I am new on MySQL and PHP. > > I'm making a on-line dictionary. I use PHP and a MySQL Database. > > Now I want to add audio-streaming (MP3) and pictures (JPG) to the database > > and retrieve it true PHP. Can sombody help me out with a little > > example-code? > > The database is working well (only text). > > > > Danny > > > > > > > > > >