FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » How To » New members with old posts linked in profile
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: New members with old posts linked in profile [message #21292 is a reply to message #21290] Wed, 24 November 2004 18:41 Go to previous messageGo to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma:
Senior Member
Administrator
Core Developer
The where condition of that query fetches a particular message who's id is know, this is something you cannot rely upon.

The query should be something like this:
"SELECT m.subject, m.id, m.post_stamp, t.forum_id 
FROM {SQL_TABLE_PREFIX}msg m
INNER JOIN {SQL_TABLE_PREFIX}thread t ON m.thread_id=t.id WHERE m.apr=1  AND m.poster_id=".$u->id."
ORDER BY m.post_stamp DESC LIMIT 1"


FUDforum Core Developer

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Is the new flat "category" listing an option?
Next Topic: Custom Titles
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 12:30:42 GMT 2024

Total time taken to generate the page: 0.04419 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software