Query to get threads ?

[FBI]

see attachments

for this query, which one should be join (change) with thread prefix

PHP Code:

1 2 3 4 5 6 7 8 9 10

$thread-trend = ''; $query = $db->simple_select('threads', '*', "fid='35' ORDER BY tid DESC LIMIT 10"); while($thread-trend = $db->fetch_array($query)) { if(my_strlen($thread-trend['subject']) > 55) { $thread-trend['subject'] = my_substr($thread-trend['subject'], 0, 55) . "..."; } eval("\$trend .= \"".$templates->get("portal_latest_trend")."\";"); }

---