Hallo ik heb een pagina met sql die heb ik niet zelf gemakt maar werkt prima.
Allen de foto’s werk niet goed ik krijg bij alle items zelfde foto.
Kan iemand mij helpen?
Bedankt .
<?
include_once("inc_connect.php");
$query = mysql_query("SELECT * FROM movie ORDER BY ean") or die(mysql_error());
$content = "";
$content .= "<div class=\"content\">";
$paginatie = "";
if (mysql_num_rows($query) > 0 ){
//create pages
$pg = empty($_GET['pg']) ? 1 : $_GET['pg'];
$catePePag = "5"; // no of items per page
$nrIntrari = mysql_num_rows($query);
$rij = mysql_fetch_assoc($query);
$rest = ($nrIntrari % $catePePag);
$nrPag = IntVal($nrIntrari / $catePePag);
$paginatie = "Page: ";
if ($rest <> 0)
$nrPag = $nrPag + 1;
for ($i=1; $i<=$nrPag; $i++) {
if ($i == $pg)
$paginatie .=" <b>".$i."</b> ";
else
$paginatie .= "<a href=\"index.php?&pg=".$i."\">".$i."</a> ";
}
if ((!intval($pg)) or ($pg > $nrPag))
echo "<script>location.href('index.php?&pg=1');</script>";
$content .= "\n<h1>Books</h1>";
$content .= "<div class=\"paginatie\">";
$content .= $paginatie;
$content .= "</div>";
if ($pg == 1)
$inf = 0;
else
$inf = $catePePag * ($pg-1);
$intrariPag = mysql_query("SELECT * FROM movie ORDER BY ean DESC LIMIT " . $inf . ",". $catePePag. "") or die(mysql_error());
//end of pagination
for($i=0; $i<mysql_num_rows($intrariPag); $i++) {
$content .= "\n<dl class=\"formular\">";
$photo='../images/' . $rij["ean"] . ".jpg";
$content .='<img src="' . $photo .'">';
$content .= "<dt><strong>Name</strong></dt><dd>". mysql_result($intrariPag,$i,'naam')."</dd>";
$content .= "<dt><strong>Nevisande</strong></dt><dd>".mysql_result($intrariPag,$i,'actors')."</dd>";
$content .= "<dt><strong>Mozo</strong></dt><dd>".mysql_result($intrariPag,$i,'omschrijving')."</dd>";
$content .= "<dt><strong>download</strong></dt><dd><a href=\"book.php?ean=" .mysql_result($intrariPag,$i,'ean')."\">"
.mysql_result($intrariPag,$i,'zipnaam')."</a></dd>";
$content .= "\n</dl>";
$content .= "<div class=\"sterge\"> </div>";
if ($i != mysql_num_rows($intrariPag)-1)
$content .= "<hr />";
else
$content .= "<p style=\"margin: 4px 0; padding: 0;\"> </p>";
}
}
$content .= "<div class=\"paginatie\">";
$content .= $paginatie;
$content .= "</div>";
print $content;
?>
1.379 views