loop help?

[darkfreaks]

ok instead of limiting 50 entries a thread and then have the first couple dissappear kind of blows is there a way i can loop the following code with a limit of 25 entries per page?

 

$query2 = "SELECT * FROM vc_covenmessages WHERE catid='$catid' ORDER BY `id` DESC LIMIT 0,50";

[mikefrederick]

do you mean that entries 1-25 show on page 1, 26-50 on page two and so on?

[darkfreaks]

correct

[mikefrederick]

$query2 = "SELECT * FROM vc_covenmessages WHERE catid='$catid' ORDER BY `id` DESC LIMIT 0,50";

 

google pagination.

 

multiple ways to think it out. you set a pagenumber, $page=$_GET['page'];, $upperlimit=$page*25;, $lowerlimit=$upperlimit-25; and then

 

 

$query2 = "SELECT * FROM vc_covenmessages WHERE catid='$catid' ORDER BY `id` DESC LIMIT $lowerlimit,$upperlimit";

[darkfreaks]

now i get mysql_num_rows not a valid resource here is the line:

 

$num=mysql_num_rows($result2);

[mikefrederick]

need more code

[Northern Flame]

if all you're trying to do is pagination,

i wrote a tutorial here:

 

http://forums.tizag.com/showthread.php?t=5670

[tibberous]

Yes!

 

I'll tell you how.

 

$page = 1; // Set to 2 for the second page

$result = mysql_query("SELECT * FROM vc_covenmessages WHERE catid='$catid' ORDER BY `id` DESC LIMIT ".(($page-1)*25).",".(25)."");

while($row = mysql_fetch_row($result))
echo print_r($row, true) . "<br>\n";

 

Written but not tested, because I don't know how to make a database. LOL.