PHP blog help archive

corvinedesign

I am running a blog of sorts using my mysql database I have it working and it grabs the most recent entries and limits the selection to the last 10 entries. I want to be able to include a link at the bottom that will take the user to the 10 entries before the ones displayed. How can i edit my code to do this any help would be great here is what i have so far.

<?PHP
$conn = mysql_connect("mysql.xxx.com", "xxx", "xxx");
$db = mysql_select_db ("xxx22");
$query = "SELECT * FROM news ORDER BY 'post_date' DESC LIMIT 10;";
$result = mysql_query($query);

	while ($row = mysql_fetch_array($result)) {

	?>
	<p class=555><b><? echo $row['post_date']; ?></b></p>
	<p class=555><? echo $row['post_text']; ?></p>
	<?
	}
	?>

vaska

use a url like this...

http://www.yourblog.com/blog.php?begin=0 - this will start your entries from the first record returned according to your query...note below in your code where i added "$begin".

then...you can alter this number (via a link or some other user controlled settings) to start ?begin=10 or whatever...then it will return records LIMITting them at 10 but starting with the 10th record not the first...it's a very simple solution...however, i'm not sure if it's exactly what you were looking for...

good luck...vaska

<?PHP
$conn = mysql_connect("mysql.xxx.com", "xxx", "xxx");
$db = mysql_select_db ("xxx22");
$query = "SELECT * FROM news ORDER BY 'post_date' DESC LIMIT

$begin,10;";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {

?>
<? echo $row['post_date']; ?>
<? echo $row['post_text']; ?>
<?
}
?>

corvinedesign

this is very close i want to be able not to have to establish the begin value with a link is there a way for the script to set the blog ID from the query and then then take that value and subtract 10 for every sub page or archived content. like

$total= the greatest text ID

then when the link is clicked $begin=$total - 10

vaska

well, actually...you are looking for something a little different overall...there are two really good threads on this subject floating about from the past couple of days...just dig around...some really good code is close by...

of course, being midnight here, i can't quite recall what i should be recalling...but you'll find it...

good luck...vaska

edit...sorry, i just search back 10 pages and i couldn't find it...it's around...a really large thread about the subject...and some really smart, efficient code...

vaska

spoke too soon...found it...

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10242489

Weedpacket

The two threads are also linked to in the FAQ at the top of this forum.