Query to get threads ?

[Imran]

Hi Zinga

I ran this query

PHP Code:

$query = $db->query(" SELECT tid , subject FROM " .TABLE_PREFIX. threads." ORDER BY tid DESC LIMIT 5");

---

This gives me 5 threads from complete all forums in descending order.
But the question is I want to get threads from thread's forum where thread is.. and count and show them on showthread page.

I hooked to showthread_end. Help please Zinga

[ZiNgA BuRgA]

Are you trying to count the number of threads in a forum?

You need to put the fid of the thread in the query.  Please learn how to write SQL queries...

Probably not what you want:

PHP Code:

1 2 3 4 5 6

$query = $db->query(" SELECT tid , subject FROM " .TABLE_PREFIX. threads." WHERE tid=".$thread['tid']." ORDER BY tid DESC LIMIT 5");

---

[Imran]

Ok, this results into this error;

PHP Code:

SQL Error: 1054 - Unknown column 't' in 'where clause' Query: SELECT tid , subject FROM mybb_threads WHERE tid=t ORDER BY tid DESC LIMIT 45

---

[ZiNgA BuRgA]

You need something set for $thread['tid']

BTW, I made a mistake - it should be fid not tid.

[Imran]

Thanks Yumi, it works now.
Thank You once again.

[FBI]

IS that query resulting Thread_Prefix (1.6) also?

[Imran]

May be you can use by altering some code within this query.

[ZiNgA BuRgA]

I think thread prefixes are stored in a different table, so you'll need a join somewhere, depending on what you want.

[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")."\";"); }

---

[ZiNgA BuRgA]

I'm not sure your code above there is valid FBI.

"$thread-trend" looks like an expression, not a variable.

Either case, I don't see a join there...