How to get the 5 latest....

jjlp215

Hi all, I've got a question.
How do you take the five latest post in a DB
(MySQL) and display them on a page, with link to the proper post???
Im using MySQL and PHP 4.0.3 with IIS.
Phorum is the place where i post messages.

Would like to have something like on this page. Where you can see the latest posts.

/Jesper

watski

You can add a timestamp to each article (I think there's a type in mySQL for this) and do a

SELECT * FROM posts
ORDER BY timestamp
LIMIT 5;

Johan

lordstjohn

Count the total of Records in your db $totrec

$lastrecord = $totrec-5

Your query :

Select * from YourDatabase LIMIT $lastrecord, 5

If you want to display the last 10 :

$lastrecord = $totrec-10

Your Query :

Select * from YourDatabse LIMIT $lastrecord, 10

Regards,
André
Luxembourg

lordstjohn

If you have an autoincremental index (ID)...

Store if into a var..., create a link to create the good query when the new php is requested...

In the link of your php :

YourPhPprogram?Yourvariable=$somethingfromDB

Your new query :

SELECT * FROM YourDatabase where ID like $yourstoredvariable

jamie_webstart

That would give you the first five, to get the most recent five it needs to be:

SELECT * FROM posts ORDER BY timestamp DESC LIMIT 5

Hope that helps.

jjlp215

Hi all, thanks for all your help.
But I dont understand any of it.
I forgot to mention that I'm new to PHP
so i would like if y'all, wrote in a newbie language

/Jesper

watski

I guess you have a table holding all posts. Add a field called timeStamp of type INT and when you insert a new post, use the time() function to get the current timestamp. Insert the new post and use Jamie's SQL-query above to retrieve the five most recent posts.

Johan

jjlp215

Well now i've got them out from the DB,
but how do I make the link at the post???

I got the subject field, and want to make a link to the proper forum.

Plz help.

The code is:
$connect = mysql_pconnect(localhost, root, *********);

$db = mysql_select_db(phorum);

$stmt = "SELECT FROM nyhed order by id desc limit 5";

$result = mysql_query($stmt);

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

echo $row["subject"];       


    echo "<br>";

    }

Thanks in advance

/JEsper

jamie_webstart

Instead of:

echo $row["subject"];

put in:

echo "<a href=\"show.php?id=".$row["id"]."\">".$row["subject"]."</a>";

This will make the subject a link to the page show.php3, which will have the variable $id set when it opens from this link. You can then open the database and select the relevent post with the query:

"SELECT * FROM nyhed WHERE id='$id'"

Hope that helps

Jamie.

jjlp215

Thanks guys!!!
Got it to work now.

Jesper