News:

Please note these forums are mostly a testing ground for my SMF work and I don't really use them otherwise.

Main Menu

Paste-1184206112:v:use_geshi-1:v:type-mysql

Started by SleePy, Jul 12, 2007, 02:08 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

SleePy

SELECT m.subject, t.id_topic as topic_id, m.id_topic as mtopic_id
FROM smf_topics AS t
   INNER JOIN smf_messages AS m ON (m.id_topic = t.id_topic)
WHERE t.id_board = 6
   AND t.id_board = m.id_board
ORDER BY poster_time DESC
LIMIT 10
No siggy! :D

SleePy

SELECT m.subject, t.id_topic as topic_id, m.id_topic as mtopic_id
FROM smf_topics AS t
   INNER JOIN smf_messages AS m ON (m.id_topic = t.id_topic)
WHERE t.id_board = 6
   AND t.id_board = m.id_board
ORDER BY poster_time DESC
LIMIT 10


subject    topic_id    mtopic_id
Re: Ti::First Task:v:St::1:v:Co::00:v:Pr::0    63    63
Ti::Next Task:v:St::1:v:Co::10:v:Pr::0    66    66
Ti::First Task:v:St::1:v:Co::00:v:Pr::0    63    63
No siggy! :D