I'm looking for a dynamic/ajax pagenation script that will work with a database. I'm retrieving image-id numbers and need to show 20 images <img src "image-ID"> per page then have a page numbers at the bottom for going to the next pages. But i also would like for the page not to stay static. refresh the images without the page moving
this is an example of how my script currently display the images. I stripped out all the extra HTML coding but with the current coding it shows all of the users friends on one page.
its a template script that allows php queries to be inserted very easy.
<!--[Loop Start QUERY:SELECT * FROM $favstable LEFT JOIN $membtable ON m_id=f_fav LEFT JOIN $picstable ON f_fav=i_user WHERE f_user=$en[m_id] AND i_status=2]-->
<img src='<%dir%>images/small/<%f_fav%>-<%i_id%>.jpg' border=1></a>
thanks in advance