Adding a next and previous button

[jdimino]

Hi Everyone

I would like  to display 40 images at a time
Can someone help me to add a next and previous button, on this script?


<?PHP

mysql_connect("localhost", "xxxxxx_xxxx", "xxxx") or die(mysql_error());

mysql_select_db("xxxx_xxx") or die(mysql_error());

$sql = "SELECT * FROM `ihsreg` ORDER BY `id` DESC LIMIT 40";
$results = mysql_query($sql);

$column = 1;

print "<table>";

while(($row = mysql_fetch_assoc($results)) !== false) {   
if ($column == 1) {
print "<tr>";
}

print '
<td>
<a href="http://www.mysite/myfolder/cvdata1.php?search=' . $row['Bloom_Name'] . '">
<img src="http://www.mysite/myfolder/' . $row['Bloom_Name'] . '.jpg" width="150" height="150" border="0">
</a>
' .$row['Bloom_Name'] . '
</td>';

if ($column == 5) {
print "</tr>";
$column = 0;
}

$column++;
}

if ($column < 5) {
while ($column < 5) {
$column++;
echo "
<td>&nbsp;</td>";
}

echo "</tr>";
}

print "</table>";

[c4onastick]

There's a few good tutorials here about doing this:

http://www.phpfreaks.com/tutorial_cat/25/Page-Number--Pagination.php

Have a look at them, essentially you have to use 'LIMIT' in your mysql query, then build the page around that.

[jdimino]

Hi

I've tried to follow the tutorials, but I'm not that good in coding.
Thanks anyway