Get Media player to get MP3 path adress from MySQL
<p>My uni project website can now play a music file from a url but what I need it to do now is to get the url address
from the mysql database. The url references the mp3 file's location on the server.
I am not sure where to insert the PHP within the media player plugin code (or whether it is possible at all).
Any advice would be appreciated.</p>

<pre><code>&lt;a href="#" onclick="toggle_visibility('player');"&gt;&lt;img src="play.png" width="22" height="22"/&gt;&lt;/a&gt;
&lt;div id="player" style='display:none;&gt;

&lt;?php
$conn = mysql_connect("localhost", "ooze", "phu7eStu");
mysql_select_db ("ooze");
$query = ("select * from music where music_ID=1");
$result = mysql_query($query) or die(mysql_error()." ".$query);
while($row = mysql_fetch_array($result))
{
echo '&lt;embed type="application/x-shockwave-flash" src="http://www.google.com/reader/ui/3523697345-audio-player.swf" flashvars="audiourl='$row[content]'" width="400" height="27" quality="best"&gt;&lt;/embed&gt;';
}
mysql_close($conn);
?&gt;
&lt;/div&gt;
</code></pre>
