code to get text of first post

[bjraines]

can someone help me with the code to get the text of the first post only in a thread?

[sawz]

you mean like a preview of the thread?
http://custom.simplemachines.org/mods/index.php?mod=263

[bjraines]

not exactly , i need to know how to code it , for a custom template i am doing....

[Dragooon]

First of *what* thread?

[bjraines]

the first topic

for example here someone has started a new thread

http://www.mychemistrytutor.com/forums/high-school-chemistry/quantum-mechanical-model/

i would to know the code, for this page, how to call the text of this first post.

[Dragooon]

You can use the ID_FIRST_MSG(id_first_msg in smf 2) info in the topics table to link to the first post of the topic in messages table.
For example

Code Select Expand

SELECT t.ID_TOPIC, m.ID_MSG, m.subject, m.body
FROM {$db_prefix}topics AS t, {$db_prefix}messages AS m
WHERE t.ID_FIRST_MSG = m.ID_MSG
AND t.ID_TOPIC = <your topic id>
LIMIT 1
Is in SQL query which gets the first message of a specific topic.
To get some latest topic from one board this should do

Code Select Expand

SELECT t.ID_TOPIC, m.ID_MSG, m.subject, m.body
FROM {$db_prefix}topics AS t, {$db_prefix}messages AS m
WHERE t.ID_FIRST_MSG = m.ID_MSG
AND t.ID_BOARD = {your board id}
ORDER BY t.ID_TOPIC DESC
LIMIT 1

[bjraines]

how would i use this in the forum template to echo the topics first message?