Loop through 50 items then go to next page

What do I need to do to have this function display 52 items then create another page?


Here is the smarty template code:

{* SHOW LAST UPLOADS *}
<br>
<table cellpadding='0' cellspacing='0' class='portal_table' align='center' width='100%'>
<tr><td class='portal_header'>User Picture Uploads</td></tr>
<tr>
<td class='portal_box'>
{if $uploads_total > 0}
  {section name=uploads_loop loop=$uploads max=100000}
    {* START NEW ROW *}
    {cycle name="startrow" values="<table cellpadding='0' cellspacing='0' align='center'>,,"}
    <td class='portal_member'><a href='{$smarty_object->url('album_file',$uploads[uploads_loop].username,$uploads[uploads_loop].albumid,$uploads[uploads_loop].photoid)}'><img src='{$uploads[uploads_loop].filepath}' border='0'><br><br>{$uploads[uploads_loop].username}</a></td>
    {* END ROW AFTER 100000 RESULTS *}
    {if $smarty.section.uploads_loop.last == true}
      </tr></table>
    {else}
      {cycle name="endrow" values=",,</tr></table>"}
    {/if}
  {/section}
{else}
  {$home43}
{/if}

Here is the php code this is displayed on:
// GET RECENT UPLOADS
$uploads_query = mysql_query("SELECT m.media_id, m.media_ext, m.media_album_id, FROM_UNIXTIME( m.media_date,'%m/%y/%d %h:%i %p' ) AS uploaddate, u.user_username, u.user_id  
                                FROM se_media m, se_albums a, se_users u
                                WHERE m.media_ext in ('jpg','jpeg','gif','png','bmp')
                                AND m.media_album_id=a.album_id
                                AND a.album_user_id=u.user_id
                                ORDER BY media_date DESC LIMIT 100000");
$uploads_array = Array();
$uploads_count = 0;
while($uploads = mysql_fetch_assoc($uploads_query)) {

  // CREATE PATH FOR THUMBNAIL
  $media_path_thumb = userdir($uploads[user_id]).$uploads[media_id]."_thumb.jpg";

  $uploads_array[$uploads_count] = Array('uploaddate' => $uploads[uploaddate],
                               'photoid' => $uploads[media_id],
                               'albumid' => $uploads[media_album_id],
                               'fileext' => $uploads[media_ext],
                               'filepath' => $media_path_thumb,
                               'userid' => $uploads[user_id],
                               'username' => $uploads[user_username]);
  $uploads_count++;
}

Start Free Trial