Barry wrote:
benifactor wrote:
i have a question about what i beleive to be called archiving...
i am building a news script and would like to limit post to be
displayed per page i have done this successfully. what i am having
probplems with is displaying the next set of news.
here is my code:
<?php include("core.php"); session_start();
$gi = mysql_query("select * from news ORDER by id asc");
while ($d = mysql_fetch_array($gi)) {
$id = $d[id];
$title = $d[title];
$news = $d[news];
$poster = $d[poster];
$pdate = $d[date];
$ptime = $d[time];
?>
<b>
<u><i><?php echo("$title"); ?></u></i><br><br>
<p>
<?php $i = $i + 1; echo("$news"); ?><br><br>
Posted By: <?php echo("$poster"); ?>, On <?php echo("$pdate"); ?> @
<?php echo("$ptime"); ?> <br> <?php if ($nerd == bignerds) {
echo("<a href=\"admin.php\">Edit Post</a> "); echo(" <a
href=\"admin.php?view=delete_news&id=$id&delete=true\">Delete
Post</a><br><br>");
}
if ($i >= 1) {
break;
}
?>
</b>
<?php
}
?>
this gets it to stop after one post. i was thinking about setting a
variable on the last post displayed, but to me this doesn't seem like
the most logical way. if someone could point me in the right
direction, or send me to a tutorial on the subject i would greatly
appreaciate it...
thank you in advance
Use mysql to display.
SELECT * FROM table WHERE id > $storedone ORDER BY id DESC LIMIT 5
Gives out the 5 news on the next page after the stored one.
sorry a small mistake it has to be " id < $storedone "
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
