make sure you send the right mimetype to the client with the php header
function.
some browsers try to detect the mime-type based on the file extension if
they are unsure about the sent mime-type, but you should not rely on this
and different browsers/version are likely not to generate the result you
want.
header ("Content-Type: audio/wave") or something should do the trick.
----- Original Message -----
From: "WCBaker" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 2:21 AM
Subject: pulling audio out of a blob and playing it
>
> Hi!
>
> I store image files in a MySql table, and can upload, store and retrieve
> these binary files without problems. I also store some audio files (they
> happen to be in .wav format). I'm having difficulty dragging these audio
> files out in a way that IE and Netscape can recognize.
>
> This doesn't work:
>
> print "<EMBED src='getAudio.php3?uid=$reference_passed ' HIDDEN = FALSE
> CONTROLS = console VOLUME = 70 LOOP = FALSE width=70 height='25'
AUTOSTART
> = FALSE NAME = 'classic' MASTERSOUND >"; (script is in PHP4)
>
> The "$reference_passed" refers to a reference number in one table that
> points to a blob in another table containing the binary information.
>
> However, if I change the $reference_passed to something with a
recognizable
> extension, like .wav or .au, I get a little console and this appears to be
> usable (if only I could make a variable called $reference_passed.wav , but
I
> can't, so I cannot successfully play this file).
>
> Am I doing something really dumb here? I'd rather not store references
in
> the table and then audio files on disk. It is very tidy to have
everything
> in MySql. Could someone point the way?
>
> Thanks so much!
>
> -Warren
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
