Als ik dit script gebruik laat hij alle plaatjes zien..
Behalve het eerste plaatje uit mijn tabel van mijn database niet
Weet iemand hoe ik dit op kan lossen??
Bedankt alvast, Leendert
<?
$aantalrijen=2;
$teller=0;
echo '<table border="3" ><tr>';
while ($row_Recordset1=mysql_fetch_array($Recordset1))
?>
<td>
<form name="form1" method="post" action="">
<table width="72" height="72" border="2">
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2"><input name="imageField" type="image" src="fotos/<?php echo $row_Recordset1['pro_pics']; ?>" width="75" height="75" border="0"></td>
</tr>
</table>
<?php
$teller++;
if ($teller%$aantalrijen==0)
{ echo "</tr><tr>";
}
}
echo '</tr></table>';
?>
Hier neemt regelt mn script verschillende bladzijdes
<?php
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_la, $la);
$query_Recordset1 = "SELECT * FROM db_pro ORDER BY pro_id DESC";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $la) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
678 views