[Eikinskjaldi]

Originally Posted by zylstra

Thanks so much Eikinskjaldi! Would it be easier on the server to return this format:

user post
firstpost
user post
firstpost
...

even though the firstpost might be repeated?

yes it would.

[sql]
select p.username, p.pagetext, q.username, q.pagetext
from post p
joint thread t using (threadid)
join post q on (t.firstpostid=q.postid)
where p.userid=your_users_id
[/sql]