coding problem for <embed> wav file

[Zepher2]

I have sound files and store the url for each in a data base. The user should be able to select a random wav file and then play the associated wav file. I have the database prtion working fine but when I try to play the wav file I get a blank screen - no error messages - no player just a blank screen. Can anyone tell me what I am doing wrong.
Here is the code:

<?

mysql_connect("localhost","xxxxxxxxxx","xxxxxx") or die ('I cannot connect to the database because: ' . mysql_error());

//Select the database we want to use
mysql_select_db("xxxxxxxx");

// set value for article selection
//$ID= $_REQUEST['ID'];

$result = mysql_query(" SELECT * FROM audio WHERE id = $random");
$myrow = mysql_fetch_array($result);

echo $myrow["id"];
echo $myrow["title"];

echo "<p>\n";
echo $myrow["url"];

echo "<EMBED SRC= ($myrow['url']) WIDTH='366' HEIGHT='45' AUTOPLAY='false' CONTROLLER='true' CACHE='true' TYPE='audio/wav' ALIGN='BOTTOM'>";

echo "<p>\n";

//Close the database connection
mysql_close();
?>

Thanks in advance for any help you can give

[sarahk]

this should be fairly simple.

firstly this needs to be changed

//from
echo "<EMBED SRC= ($myrow['url']) WIDTH='366' HEIGHT='45' AUTOPLAY='false' CONTROLLER='true' CACHE='true' TYPE='audio/wav' ALIGN='BOTTOM'>"; 

//to
echo "<EMBED SRC='{$myrow['url']}' WIDTH='366' HEIGHT='45' AUTOPLAY='false' CONTROLLER='true' CACHE='true' TYPE='audio/wav' ALIGN='BOTTOM'>"; 

to check where the error is use the "view source" feature in your browser. All the PHP is doing is spitting out html. Looking at the html that is produced is always a good way to find out where your script is going wrong.

[Zepher2]

Thanks for the help that was my error.