Hi all the people, me one more time bothering, but i need help, i don't know PHP so much, neither MySQL, but i did the code with a guide and Dreamweaver, so i need someone who can complete it, i don't know how to call the Thumb of every album, please help me to complete it please!!!
<?php require_once('Latest_album_connect.php'); ?>
<?php
$maxRows_latest_album = 5;
$pageNum_latest_album = 0;
if (isset($_GET['pageNum_latest_album'])) {
$pageNum_latest_album = $_GET['pageNum_latest_album'];
}
$startRow_latest_album = $pageNum_latest_album * $maxRows_latest_album;
mysql_select_db($database_Latest_album_connect, $Latest_album_connect);
$query_latest_album = "SELECT * FROM cpg_albums ORDER BY aid DESC";
$query_limit_latest_album = sprintf("%s LIMIT %d, %d", $query_latest_album, $startRow_latest_album, $maxRows_latest_album);
$latest_album = mysql_query($query_limit_latest_album, $Latest_album_connect) or die(mysql_error());
$row_latest_album = mysql_fetch_assoc($latest_album);
if (isset($_GET['totalRows_latest_album'])) {
$totalRows_latest_album = $_GET['totalRows_latest_album'];
} else {
$all_latest_album = mysql_query($query_latest_album);
$totalRows_latest_album = mysql_num_rows($all_latest_album);
}
$totalPages_latest_album = ceil($totalRows_latest_album/$maxRows_latest_album)-1;
?>
<html>
<head>
<title></title>
</head>
<body>
<?php do { ?>
<a title="<?php echo $row_latest_album['title']; ?>" target="_blank" href="Galeria/thumbnails.php?album=<?php echo $row_latest_album['aid']; ?>"><img src="<?php echo $thumb_url['thumb']; ?>" border="0"></a><br>
<?php } while ($row_latest_album = mysql_fetch_assoc($latest_album)); ?>
</body>
</html>
<?php
mysql_free_result($latest_album);
?>