I received a partial resolution to this issue but have another question. When I directly add
urlencode() to my php page to post a variable. I can read it and process it with no problem; as in this code. echo “&yorName=As&”;. I put this in and have no problems reading playing this song. However when I try to call from mysql, it will call the variable fine, I have it echo so I see it pulling the right variable(song), but it won’t play. Again, using the code above it will play fine, but when I call it from mysql it won’t play. Here is the code I use. I pull from the db fine.
<?php
include (‘connect_music.php’);
//Collect Form Data
$string = $_POST[‘artist’];
$string2 = $_POST[‘song’];
$string3 = $_POST[‘album’];
//Issue SQL SELECT Statement
$sql2 = “SELECT song,artist,album FROM music WHERE song = ‘$string2’”;
$rs2 = mysql_query($sql2, $link);
if(!empty($_POST))
{
while($row2 = mysql_fetch_array($rs2))
{
echo “<strong>Song Found</strong>:”. " ". " ". $row2[‘song’]. “<br/>”;
}
$mysong = $row2[‘song’];
echo “&yorName=$mysong&”;
}
?>
It pulls the variable and shows on the screen, but will not play. Again if I just say echo “&yorName=As&”; and manually put the variable in, it loads and plays fine**.**
