بفرمایید کد فایل index.php:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<title>Skitter - Slideshow for anytime!</title>
<link href="css/styles.css" type="text/css" media="all" rel="stylesheet" />
<!-- Skitter Styles -->
<link href="css/skitter.styles.css" type="text/css" media="all" rel="stylesheet" />
<!-- Skitter JS -->
<script type="text/javascript" language="javascript" src="js/jquery-1.6.3.min.js"></script>
<script type="text/javascript" language="javascript" src="js/jquery.easing.1.3.js"></script>
<script type="text/javascript" language="javascript" src="js/jquery.animate-colors-min.js"></script>
<script type="text/javascript" language="javascript" src="js/jquery.skitter.min.js"></script>
<!-- Init Skitter -->
<script type="text/javascript" language="javascript">
$(document).ready(function() {
$('.box_skitter_large').skitter({
theme: 'clean',
numbers_align: 'center',
progressbar: true,
dots: true,
preview: true
});
});
</script>
</head>
<body>
<div id="page">
<h1>Skitter - Slideshow for anytime!</h1>
<div id="content">
<div class="border_box">
<div class="box_skitter box_skitter_large">
<ul>
<?php
require_once('db.php');
$conn = db_connect();
$result = $conn->query("select * from banner ");
while ($row = $result->fetch_assoc()) {
?>
<li><a target="_blank" href="<?php echo $row['link']; ?>"><img border="0" src="<?php echo $row['pic']; ?>" width="468" height="60" class="cube" /></a><div class="label_text"><p>cube</p></div></li>
<?php } ?>
</ul>
</body>
</html>
شما باید از حلقه while استفاده میکردید.