$album_id = strtolower($HTTP_GET_VARS['id']); $strDataSource = "genivcom.ipowermysql.com"; $strUser = "genivcom_geniv"; $strPw = "potd1234"; $db = mysql_pconnect( $strDataSource, $strUser, $strPw) or die ('I cannot connect to the database.'); mysql_select_db("genivcom_geniv"); $strsql = "SELECT * FROM Lyrics where lyric_id = '$album_id'"; $rs = mysql_query($strsql, $db); while ($myrow = mysql_fetch_array($rs)) { $l_id = $myrow["lyric_id"]; $l_artist_name = $myrow["lyric_artist_name"]; $l_text = $myrow["lyric_text"]; $l_album_name = $myrow["lyric_album_name"]; $l_album_pic = $myrow["album_pic"]; } mysql_close($db); ?>