Pulling last post from db

[pinehead18]

I have a mini forum on my site and i would like to pull the last post from the db.

       $lsql = "SELECT date,author FROM threads WHERE tid='$topic_id'";

That is my code, it only pulls the first post date with the topic_id, but i want it to pull the last one posted by topic_id. I would do order by id, but will that work if i'm onlypulling one result?

[lilleman]

Hi,

I assume that the table has a primary field called id. If that's the case, you should be able to do like this.

$lsql = "SELECT date,author FROM threads WHERE tid='$topic_id' ORDER BY id DESC LIMIT 1";

Yours, Erik.

[TheDefender]

lilleman, I think the tid is the id field...

$lsql = "SELECT date,author FROM threads WHERE tid='$topic_id' ORDER BY tid DESC LIMIT 1";

pinehead18, you could also ORDER it by the date too.

$lsql = "SELECT date,author FROM threads WHERE tid='$topic_id' ORDER BY date DESC LIMIT 1";