Re: Re: Pictures and sound in MySQL and access via PHP

thank you for your answer How do you make a link in MySQL? I tried following code were the field "geluid" contains a link to a mp3 format of field geluid = varchar(250). The problem is that i just get plain text instead of a link to the MP3. Even better would be to have a button to clicjk if you want to hear the sound. echo "<table width=\"90%\" border=1><tr><td>"; echo "Nederlands</td><td>Oostends</td><td>Uitleg</td></tr>"; while ($row=mysql_fetch_array($result)) { echo "<tr><td>"; echo $row[woord_nl]. "</td><td>" . $row[woord_ost]. "</td><td>" . $row[betekenis_nl]. "</td><td>" . $row[geluid]; echo "</td></tr>"; } Danny Rodolfo Gonzalez <rodolfo@equinoxe.g-networks.net> schreef in berichtnieuws Pine.LNX.4.44.0208111007200.26918-100000@main.g-networks.net... > On Sat, 10 Aug 2002, lallous wrote: > > > 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 > > If the files are not "secret" or "for members only", you should better > store them somewhere under your http document tree, and store *only* their > filenames in the database, then you could provide a link to the file. I > think this would be the faster. Or if you want to "protect" the files, you > could place them outside your document tree, and then use fileread or > something similar to read them. But I'd suggest you to keep only the > filenames on the database, and store the files in the filesystem, it'd > better for the performance and integrity of the files. > > Good luck. > > >