echo "<table border='1'>";
$query = "select * from movie_songs_download where lower(movie) like '%$test%'";
$result = mysql_query($query);
echo "<tr> <th>Movie</th> <th>Song</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['Movie'];
	echo "</td><td>"; 
	echo $row['Link'];
	echo "</td></tr>"; 
} 
echo "</table>";