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>";

Rodolfo Gonzalez <[EMAIL PROTECTED]> schreef in berichtnieuws
> 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
> > > 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.

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to