jdimino Posted December 16, 2006 Share Posted December 16, 2006 Hi EveryoneI would like to display 40 images at a timeCan someone help me to add a next and previous button, on this script?<?PHPmysql_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> </td>"; } echo "</tr>";}print "</table>"; Quote Link to comment Share on other sites More sharing options...
c4onastick Posted December 16, 2006 Share Posted December 16, 2006 There's a few good tutorials here about doing this:http://www.phpfreaks.com/tutorial_cat/25/Page-Number--Pagination.phpHave a look at them, essentially you have to use 'LIMIT' in your mysql query, then build the page around that. Quote Link to comment Share on other sites More sharing options...
jdimino Posted December 16, 2006 Author Share Posted December 16, 2006 HiI've tried to follow the tutorials, but I'm not that good in coding.Thanks anyway Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.