paging

[slimjim]

Using the below, how can I do paging?

It will make one page as it stands now, but if there are to many, then of course I would need paging into it.

Sorta like how they have this :
http://www.phpbuilder.com/board/archive/index.php/f-3-p-58.html

Is this possible ?

$fp = fopen("test.html", "w");
fwrite($fp, $header); 	

$q = "select url from faver"; 
$r = mysql_query($q); 

while($data = mysql_fetch_row($r)) {
fwrite($fp, '<a href="' . $data[0] . '">link text</a></br />');  

} 
fwrite($fp, $footer); 

fclose($fp);

[musicbase]

I suggest you create a backup copy first, then
Replace

$q = "select url from faver"; 

with

$q = "select url from faver limit $start,20"; 

Then in the place where you want your page numbers, put this:

$pn=0;
echo "<br>Pages: ";
$tmsgs=mysql_num_rows(mysql_query("SELECT url FROM faver"));
if ($start<>0)
{
$numap=$start-20;
echo "<a href='?start=$numap'>";} echo"Previous Page</a> |&nbsp;"; //change link


while($tmsgs-$num>0){

$pn++;
if ($num<>$start)
{
echo "<a href='?start=$num'>$pn</a>&nbsp;|&nbsp;"; //change link
}
else 
{
echo "$pn&nbsp; |&nbsp;";}

$num+=20;
}
$numa=$start+20;
if ($tmsgs-$numa>0)
{
echo"<a href='?start=$numa'>";} echo"Next Page</a>"; //changelink

}}

If you have anyother query strings in the URL that need to be carried, add them on the lines where I've written changelink.

I'm fairly sure this should work, as it works for me, but no guarentees!
Let me know if it works.

[slimjim]

Just one problem, I am fwriting the whole page.