Last Post Minute Query

[Boofo]

Logician, is there an easy way to pull out the last poster in your query for the last post minute hack? If I can do it through there, I can cut another query and have it give me the right result all at the same time.

[Logician]

I believe if changing the query to this should help:

SELECT post.dateline AS lastpostminute, thread.threadid, user.username
FROM post, thread
LEFT JOIN user ON user.userid = post.userid
WHERE thread.forumid = $forumid AND thread.threadid = post.threadid
ORDER BY post.dateline DESC
LIMIT 1

Then you can use variable $lastpostminDB[username]

[Boofo]

LOL I just did this about 5 minutes ago. Here is the code I used and it seems to work.

PHP Code:

$lastpostminDB=$DB_site->query_first("SELECT post.dateline as thread.threadid, username, userid FROM post,thread WHERE thread.forumid=$forumid AND thread.threadid=post.threadid ORDER BY post.dateline DESC LIMIT 1"); 


I use $lastpostminDB[username] for the last poster and $lastpostminDB[userid] for the link to the member's profile.

Will this code work or am I just lucky right now and it will mess up later?

[Logician]

I say go with my code (if it is working, I didn't test it!). For some reason getting the username from thread/post tables sometimes not works. This is why I put the left join query in my code to get it from the user table.

[Boofo]

Thank you, sir. I'll go test it now and report back.

[Boofo]

Ok, tested and got no errors. How do I call the userid for the link to the user's profile now? I have been trying everything and can't find anything to work.

[Logician]

SELECT post.dateline AS lastpostminute, thread.threadid, user.username, user.userid
FROM post, thread
LEFT JOIN user ON user.userid = post.userid
WHERE thread.forumid = $forumid AND thread.threadid = post.threadid
ORDER BY post.dateline DESC
LIMIT 1

[Boofo]

Thank you, again, sir. I guess I still don't have the hang of these queries, yet.