Error number: ' . mysql_errno() . 'Cannot connect to database');
mysql_select_db($db) or die ('Error: ' . mysql_error() . '
Error number: ' . mysql_errno() . '
Cannot connect to database');
$album_query = mysql_query("SELECT * FROM `albums`");
$album_table = '
| Artist | Title | Rapidshare | Megaupload |
|---|
';
while($row = mysql_fetch_array($album_query)){
$album_id = $row['album_id'];
$rapidshare_query = mysql_query("SELECT `link` FROM `rapidshare` WHERE `album_id` = '$album_id'");
$array_rs = mysql_fetch_array($rapidshare_query);
$rapidshare = $array_rs['link'];
$muquery = mysql_query("SELECT `link` FROM `megaupload` WHERE `album_id` = '$album_id');
$array_mu = mysql_fetch_array($muquery);
$mu = $array_mu['link'];
$artist = $row['artist'];
$title = $row['title'];
$rslink = 'No Link';
$mulink = 'No Link';
if (strlen($rapidshare) > 0){
$mulink = "$title Megaupload";
}
if (strlen($mu) > 0){
$rslink = "$title Rapidshare";
}
$album_table .= "| $artist | $title | $rslink | $mulink |
";
}
$album_table .= '
';
echo $album_table;
mysql_close($mysql);
exit('woop we made it');
?>