archiving

[Anon]

Ok, i need some help here. I have the news and the links on my page dynamically rendered. Now i dont want to have a really long page filled with the content that builds up. How do i make a script that after a certain amount of posts creates a link like "archive" and sends it to a dynamically created page like index.php?section=news&page=2? Any help would be a huge help. thanks.

Kyle Dreaden
Kulao Networks

[chowdary]

Hi,
Just now i posted a reply to the topic "Prev and Next" . See whether it it works for you

Cheers
Ajay

[Anon]

no i dont think that will help. i need somthing for my special situation heh. im going to post my source and see what happens. thanks though.

[Anon]

<font face="veranda" size="1">
<?php
mysql_connect('localhost','myusre','mypass');
mysql_select_db('dreden');
$result = mysql_query("select * from news ORDER by id desc");
while($r = mysql_fetch_row($result)) {
echo ("<b><i>$r[1] | Posted by $r[2] | on $r[3]</i></b><br> ");
echo ("<div align=\"justified\">");
echo ("$r[4]<br><br>");
echo ("</div");
}
?>
</font>

Ok, how do i make that do what i asked about in the original post?

[chowdary]

Hi,
If you want to display only few on this page and give link to another page then
<?php
mysql_connect('localhost','myusre','mypass');
mysql_select_db('dreden');
$result = mysql_query("select * from news ORDER by id desc");
$num_of_posts=mysql_num_rows($result);
// The number of post you want to display
$max_posts=4;
while($r = mysql_fetch_row($result)) {
$rowno++;
if($rowno<=$max_posts){
echo ("$r[1] | Posted by $r[2] | on $r[3]<br> ");
echo ("<div align=\"justified\">");
echo ("$r[4]<br><br>");
echo ("</div");
}
}

// Now if there are more posts to be displayed

if($num_of_posts>$max_posts){
// give link to wherever you want
}

?>

Cheers
Ajay

In while

[Anon]

so where i put a link to the second page, it can be anything? like section=news&page=2 without there even being an accual page2 file?