display oembed for a list of souncloud urls
I am using a simple database and php structure to preview new tracks for our label. 
right now it displays the links and i just click the link and then listen on soundcloud. 

What i would like to do - 
I want to take the regular urls that display on the page and turn them into widgets using oEmbed.

I tried this but no avail

        <?php
    echo'<head>
    <title>blah blah title</title>
    </head>
      <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
      <script src="http://connect.soundcloud.com/sdk.js"></script>
    ';
    
    $con = mysql_connect("localhost","user","pass");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("thedance_record_labels", $con);
    
    $result = mysql_query("SELECT * FROM new_submissions ORDER BY id ASC") //WHERE artist_name='matt'
    or die(mysql_error());
    
    
    while($row = mysql_fetch_array($result))
      {
    	echo '<table class="curvedEdges">';
    	echo '<tr>';
    	echo '<td>';
    	echo '<b>';
    	echo $row["artist_name"] .' ';
    	echo '</b>';
    	echo '   |   ';
    	echo '<a class="soundcloud-link" href="'.$row["url"].'" />'.$row["url"].'</a>';
    	echo '</b>';
    	echo '   |   ';
    	echo '<a href="'.$row["email"].'" />'.$row["email"].'</a>';
    	echo '</td>';
    	
    	
    	echo '
    	<script>
      $(function(){
        $(".soundcloud-link").click(function(e){
            e.preventDefault();
            SC.oEmbed($(this).attr("href"), {auto_play: true}, $(".player").get(0));
        });
      });
      </script>
      ';
    
      }
    ?>


Thanks in advance!
display oembed for a list of souncloud urls
===

I am using a simple database and php structure to preview new tracks for our label. 
right now it displays the links and i just click the link and then listen on soundcloud. 

What i would like to do - 
I want to take the regular urls that display on the page and turn them into widgets using oEmbed.

I tried this but no avail

        <?php
    echo'<head>
    <title>blah blah title</title>
    </head>
      <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
      <script src="http://connect.soundcloud.com/sdk.js"></script>
    ';
    
    $con = mysql_connect("localhost","user","pass");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("thedance_record_labels", $con);
    
    $result = mysql_query("SELECT * FROM new_submissions ORDER BY id ASC") //WHERE artist_name='matt'
    or die(mysql_error());
    
    
    while($row = mysql_fetch_array($result))
      {
    	echo '<table class="curvedEdges">';
    	echo '<tr>';
    	echo '<td>';
    	echo '<b>';
    	echo $row["artist_name"] .' ';
    	echo '</b>';
    	echo '   |   ';
    	echo '<a class="soundcloud-link" href="'.$row["url"].'" />'.$row["url"].'</a>';
    	echo '</b>';
    	echo '   |   ';
    	echo '<a href="'.$row["email"].'" />'.$row["email"].'</a>';
    	echo '</td>';
    	
    	
    	echo '
    	<script>
      $(function(){
        $(".soundcloud-link").click(function(e){
            e.preventDefault();
            SC.oEmbed($(this).attr("href"), {auto_play: true}, $(".player").get(0));
        });
      });
      </script>
      ';
    
      }
    ?>


Thanks in advance!