doğru anladıysam eğer
$cek = mysql_query("select lyrics.id,lyrics.title,artists.artist from lyrics inner join artists on lyrics.iid = artists.id where artists.id = '$id' order by lyrics.title asc");
işini görmesi lazım