| Dr.CustUmz |
02-18-2017 10:28 PM |
FOREACH threadid get thread tittle in post
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>';
|
More Information