$name_string = strtolower($HTTP_GET_VARS['name']); $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 amw where artist_english_name='$name_string' and disk_number='1' and song_number='1' order by id"; $rs = mysql_query($strsql, $db); $i = 0; while ($myrow = mysql_fetch_array($rs)) { $cd_image[$i] = $myrow["album_image"]; $cd_album_name[$i] = $myrow["album_name"]; $cd_chinese_name[$i] = $myrow["chinese_name"]; $cd_english_name[$i] = $myrow["artist_english_name"]; $cd_yesasia[$i] = $myrow["sponsor_link1"]; $cd_id[$i] = $myrow["id"]; $cd_release[$i] = $myrow["string1"]; $i=$i+1; } mysql_close($db); ?>
.:: buy ::. | album name: $cd_album_name[$i] | release date: $cd_release[$i] | "; echo "