Untitled

<?php

$mysql = mysql_connect($server, $sqlname, $password) or die ('Error: ' . mysql_error() . '<BR>Error number: ' . mysql_errno() . '<P><b>Cannot connect to database</b>');
mysql_select_db($db) or die ('Error: ' . mysql_error() . '<BR>Error number: ' . mysql_errno() . '<P><b>Cannot connect to database</b>');

$album_query = mysql_query("SELECT * FROM `albums`");
$album_table = '<table border="1%"><tr><th>Artist</th><th>Title</th><th>Rapidshare</th><th>Megaupload</th></tr>';

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 = "<a href=\"$mu\" target=\"_blank\">$title Megaupload</a>";
  }

  if (strlen($mu) > 0){
   $rslink = "<a href=\"$rapidshare\" target=\"_blank\">$title Rapidshare</a>";
  }

$album_table .= "<tr><td>$artist</td><td>$title</td><td>$rslink</td><td>$mulink</td></tr>";

}

$album_table .= '</table>';
echo $album_table;
mysql_close($mysql);
exit('woop we made it');
?>