[Dr.CustUmz]

I have an input field when creating a new thread, where you can enter multiple thread I.D's (separated by commas).

I return the results with '$someVariable' in the postbit template.

I explode those thread I.D's in 'showthread_postbit_create' with:

PHP Code:

$someVariable = '<ul>';
$ret = $post['thread_ids'];
$ret = explode (',', $ret);
foreach ( $ret as $res ) {
  $post['thread_ids'] .= '<li><a href="showthread.php?t=' . $res . '">LINK</a></li>';
}
$post['thread_ids'] .= '</ul>'; 


This gives me a list of links with a link to each thread specified in the input, but what I am failing to get is the thread title.

I need something like:

PHP Code:

$post['thread_ids'] .= '<li><a href="showthread.php?t=' . $res . '">'. $post[thread_id_title] .'</a></li>'; 


But I can't seem to figure out how to grab those titles, any help would be much appreciated.


Just an update of where I'm at right now: (lost as can be lol)

PHP Code:

if (in_array ($post['thread_ids'], explode (',', $post['thread_ids']))) {
  $db->query ("SELECT thread.title" . TABLE_PREFIX . "thread WHERE thread.threadid IN (" . implode(',', $post['thread_ids']) . "));
} 


Last update for the night: (where I'm at currently, still no luck)

PHP Code:

$post['thread_ids'] = '<ul>';
$ret = $post['thread_ids'];
$ret = explode (',', $ret);

$db->query("
  SELECT
  thread.threadid, drc.threadid AS threadid,
  thread.threadid, thread.title AS threadtitle
  FROM " . TABLE_PREFIX . "thread AS thread
  LEFT JOIN " . TABLE_PREFIX . "drc_settings AS drc ON (drc.threadid=thread.threadid)
  WHERE thread.threadid VAR (" . $ret . ")
");


foreach ( $addons as $res ) {
  $post['thread_ids'] .= '<li><a href="showthread.php?t=' . $res . '">'. $thread[threadtitle] .'</a></li>';
}
$post['thread_ids'] .= '</ul>';