Multiple Pages

Ok, well I don`t know how to make more pages to view more news, but I do know how to make a "news on page limit" If you use a statement in your code like this:" q= SELECT * FROM (table here) " Put " DESC LIMIT= 0,(how many news posts you want on a page) "at the end. It should look like this: "q= SELECT * FROM (table) DESC LIMIT=0,(number)" Hope that helps!

Meh

p00p! I forgot to put $`s in front of the q`s.

Meh

Oh ok, I`ll try and find a solution then......

Meh

$_switch_page['post']
[safe]$_switch_page['post']*;

Hi there! I've returned!

Nope! A random script I made with PHP.net. :D Works on PHP V.8.9, coming soon! :D

Hi there! I've returned!

Pagination is very complicated.
I can post what I use on my site, but you MUST know advanced php and SQL. Or it will appear as gibberish. And it won't work if you don't know what to do.

Here's what I did for my guestbook:

$sql = '
SELECT COUNT(1) AS `posts`
FROM t_guestbook
WHERE active = "true"';
if($result = $mysqli->query($sql)){
if($row = $result->fetch_object()){
$post_count = $row->posts;
$page_count = ceil($post_count/20);
}
}

if(!(int)$_GET['page']){
$_GET['page'] = 0;
}

if($_GET['page']>=$page_count){
$_GET['page'] = $page_count-1;
}

<?php

}
$sql = '
SELECT *
FROM (table)
WHERE (condition(optional))
ORDER BY (column) DESC
LIMIT ' . (int)($_GET['page']*20) . ', 20';
if($result = $mysqli->query($sql)){
echo '

<tr style="background:#fff">
<td>
' . ($_GET['page']>0 ? '<a class="page" href="?page=0"><<</a> || <a class="page" href="?page=' . ($_GET['page']-1) . '"><</a>' : '') . '

|||||
' . ($_GET['page']<$page_count-1 ? '<a class="page" href="?page=' . ($_GET['page']+1) . '">></a> || <a class="page" href="?page=' . ($page_count-1) . '">>></a>' : '') . '

</td>
</tr>
';

while($row = $result->fetch_object()){
    
?>
All that above is the pagination. Now, here is where the table retrieving data would go, then you end it like this:
<?php
}
}
?>

And BOOM you're done. Btw, this limits the results to 20 per page. You can easily change that by changing all the 20's to 10's.

I know my apprehensions might never be allayed. And so I close, realizing that perhaps the ending has not yet been written...

The winky eyes (;)) are this, without spaces:
; )

I know my apprehensions might never be allayed. And so I close, realizing that perhaps the ending has not yet been written...

Any syntax errors or other complications, send me a message.

I know my apprehensions might never be allayed. And so I close, realizing that perhaps the ending has not yet been written...

That's actually a very simple method of pagination.

I know my apprehensions might never be allayed. And so I close, realizing that perhaps the ending has not yet been written...