How do I do that?
Thanks
Moderator: General Moderators
Code: Select all
$startVal = 0;
$perPage = 10;
$sql = 'SELECT * FROM posts ORDER BY dtDateTime DESC LIMIT '.$startVal.','.$perPage;
...
<a href="ShowPosts.php?startVal=<?php echo $startVal+1; ?>&perPage=<?php echo $perPage; ?>">Next Ten</a>Code: Select all
<?php
mysql_connect($DBhost,$DBuser,$DBpass) or
die("Unable to connect to database");
@mysql_select_db("$DBname") or die("Unable to select database");
$sqlquery = "SELECT * From posts order by 'post_id' DESC";
$result=mysql_query($sqlquery);
$num=mysql_num_rows($result);
$i=0;
while ($i < 5) {
$post_id=mysql_result($result,$i,'post_id');
$post=mysql_result($result,$i,'post');
++$i; }
?>