search.php

if(isset($_POST['search_term']))
{
    $search_term = mysql_real_escape_string($_POST['search_term']);
    if(!empty($_POST['search_term']))
    {
        $song_search = mysql_query("SELECT  songTitle, songID FROM songs WHERE songTitle LIKE '%$search_term%'");
        $song_result_count = mysql_num_rows($song_search);

        echo "<p>".$song_result_count." Songs match \"".$search_term."\"  </p>";
        echo "<div class='search-result-wrap'><table width='100%'>";
        while($result_item = mysql_fetch_array($song_search))
        {
            echo "<tr class='play' id='".$result_item[0]."' value='".$result_item[1]."'><td>".$result_item[0]."</td></tr>";
        }
        echo "</table></div>";


    }
    else
    {
        echo "<p>Type search criteria in the box above</p>";
    }