Query Problems

[Kirk Y]

I'm using this SQL query to retrieve the first post within a thread, where the thread id is specified in the URL.

[sql]SELECT post.pagetext, post.postid, post.threadid, post.username, post.userid, post.dateline, post.iconid, post.pagetext, icon.iconid, icon.title, icon.iconpath, thread.threadid, thread.title, thread.lastpost, thread.forumid
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON (post.iconid = icon.iconid)
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON(post.threadid = thread.threadid )
WHERE thread.threadid = " . $id . "[/sql]

Problem being, the first post isn't being retrieved.

Edit: No wonder - I forgot the ORDER BY - d'oh! :cross-eyed: