how to create direct URL instead of query

[supa5teph]

Hi there... this is my first call for help on a forum!


i'm trying to use a flash based mp3 player. it's simple to use (wimpyplayer.com - the button). all you have to do is enter in the path name to the mp3 file.

the problem i'm running into is that it doesn't play on IE6. firefox is fine.

i did get the demo to work on IE6, but it only works with the extension ".mp3". it does not play with a mysql query, such as "audio.php?ID=40".

so my question is... in the database table, i do store the file name of the audio file. how can i convert "audio.php?ID=40" into a direct URL, "audio.mp3"?

please help!! any help would be appreciated at this point.

Here is my snippet of code:

[quote] $fileURL = rawurlencode('http://napi.net-flow.com/alanschwarz.com/pubs_display_story_object.php?ID=' . get_field("ID"));
print "<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,47,0\" width=\"17\" height=\"17\" id=\"wimpy_button_$count\" name=\"wimpy_button_$count\" >\n";
print "<param name=\"movie\" value=\"wimpy_button.swf?theFile=$fileURL&autoplay=no&loopMe=no\"/>\n";
print "<param name=\"quality\" value=\"high\" />\n";
print "<param name=\"bgcolor\" value=\"#FFFFFF\" />\n";
print "<embed src=\"wimpy_button.swf?theFile=$fileURL&autoplay=no&loopMe=no\" width=\"17\" height=\"17\" quality=\"high\" bgcolor=\"#6A7A95\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"  name=\"wimpy_button_$count\" /></object>\n";
[/quote]

and the output is here: http://alanschwarz.net-flow.com/audio/index.html

any help would be appreciated!

[fenway]

I find it hard to believe that it actually cares about the extension, but it's possible.  If so, simple store the filename you extract from the ID, and use it directly.