Hi
I got this code below that I'm using in a blog, and as you can see its limited to 25 how do i put a page 1,2,3,4 ext on to this
thanks
mrdeleigh
if(get_param("search_box") == "")
{ $strLatestVideos = '
<table cellspacing=1 cellpadding=0>
<tr>
<td class="right_block_table_first_TD" colspan="2">
LATEST VIDEOS
</td>
</tr>
';
$tableVideos = DataTable_Query("
SELECT author_image, date, ".$DBprefix."weblog.user, title, ".$DBprefix."notes.id , ".$DBprefix."notes.video
FROM ".$DBprefix."notes,".$DBprefix."weblog,".$DBprefix."admin_users WHERE ".$DBprefix."notes.user=".$DBprefix."weblog.user
AND ".$DBprefix."notes.user=".$DBprefix."admin_users.username
AND blog_active=1
AND category_id<>-1
".($SHOW_ONLY_NOTES_WITH_PHOTO?"AND author_image<>0":"")."
AND active='YES'
AND show_video=1
AND video<>''
AND
(".$DBprefix."notes.title LIKE '%".get_param("search_box")."%'
OR
".$DBprefix."notes.html LIKE '%".get_param("search_box")."%'
OR
".$DBprefix."notes.user LIKE '%".get_param("search_box")."%'
)
ORDER BY date DESC LIMIT 0,25");
}
$bColor = true;
$iCounter = 1;
while($arrLastBlog = mysql_fetch_array($tableVideos))
{
if(trim($arrLastBlog["title"]) == "")
{
continue;
}
if($iCounter > $NUMBER_LATEST_NOTES)
{
break;
}
if($arrLastBlog["author_image"] > 1)
{
$author = "<a href='http://".BlogUrl($arrLastBlog["user"])."' target=_blank>";
if($USE_GD)
{
$author .= "<img src=\"thumbnail.php?id=". $arrLastBlog["author_image"]."&w=45&h=60\" width=45 height=60 border=0>";
}
else
{
$author .= "<img src=\"image.php?id=". $arrLastBlog["author_image"]."&w=45&h=60\" width=45 height=60 border=0>";
}
$author .= "</a>";
}
else
{
$author = "<img src=ADMIN/images/no_pic.gif width=45 height=60>";
}
if($arrLastBlog["user"] == "admin")
{
$strBlogger = '<font color=#d68449><b>'.strtoupper($arrLastBlog["user"]).'</b></font>';
}
else
{
$strBlogger = ''.$arrLastBlog["user"].'';
}
echo '
<tr bgcolor='.($bColor?'#ffffff':'#FAF9DA').'>
<td width="296"><a href="'.CreateLink4($arrLastBlog["user"],'note/'.$arrLastBlog["id"],$arrLastBlog["title"]).'" target=_blank>'.stripslashes($arrLastBlog["title"]).'</a></td>
<td width="99"><a href="http://'.BlogUrl($arrLastBlog["user"]).'" target=_blank>'.$strBlogger.'</a></td>
<td width=52><a href="http://'.$BLOG_DOMAIN.'/blog.php?user='.$arrLastBlog['user'].'¬e='.$arrLastBlog['id'].'&play=1" target="_blank"><img src="grab.php?id='.$arrLastBlog["video"].'" width="135" height="90" border="0"></a>
</td>
</tr>
';
$iCounter++;
$bColor = !$bColor;
}
$strLatestVideos .= '
