include '../db/config.php';
include '../db/opendb.php';
$album_id=$_GET['album']; //passed from view-album for album id clicked on
mysql_select_db($database) or die('Error, could not select the database');
$query="SELECT * FROM fc_pics WHERE in_album=$album_id ORDER BY id DESC";
$result=mysql_query($query);
if (!$result)
{echo("
Error accessing database " . mysql_error() . "
"); include
'closedb.php'; exit(); }
$num=mysql_num_rows($result);
$i=0;
print "\n";
while ($i < $num)
{
$id=mysql_result($result,$i,"id");
$desc=mysql_result($result,$i,"desc");
$author=mysql_result($result,$i,"author");
$file=mysql_result($result,$i,"file");
$thumb=mysql_result($result,$i,"thumb");
$size=mysql_result($result,$i,"size");
$views=mysql_result($result,$i,"views");
$made=mysql_result($result,$i,"create_date");
// table 8 across
print " \n";
print "$desc \n";
print "$author \n";
print "Size: $size bytes \n";
print "$made\n";
if ($i%5==4){print " |
\n";}
$i++;
}
print "
";
include 'closedb.php';
?>