"My dilema is that I am using mysql..." There's an understatmenet 😉
HTML page:
<input type=text name="artist">
<input type=submit>
PHP page:
if ($artist) {
$sql = "select whatever from wherever where artist = '$artist'";
The rest, my friend, is up to you.