how do I retrieve that info?

[Lionel]

oh boy, I figured it out. Had to go to the functions_showthread, define a global and put it in that postbit section. Can't believe I did it. Don't even kow php and mysql. The whole thing has been trial and error and help from people like you.

[Logikos]

Originally Posted by Lionel

oh boy, I figured it out. Had to go to the functions_showthread, define a global and put it in that postbit section. Can't believe I did it. Don't even kow php and mysql. The whole thing has been trial and error and help from people like you.

Hey i learned the little i know the same way, "does this work if i do that?" [refreshes page] "error" DAMMIT! lol

thats me till i get it right.

[Lionel]

oops. This is returning only one item

$pollist = $DB_site->query("SELECT
thread.threadid AS thread_id,thread.title AS thread_title,thread.pollid AS thread_pollid,poll.pollid AS poll_pollid,
poll.active AS poll_active,poll.dateline AS poll_dateline,poll.public AS poll_public,user.userid,user.username
FROM
" . TABLE_PREFIX . "thread AS thread,
" . TABLE_PREFIX . "poll AS poll,
" . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS dlog_t ON (dlog_t.primaryid = thread.threadid AND dlog_t.type = 'thread')
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS dlog_p ON (dlog_p.primaryid = poll.pollid AND dlog_p.type = 'poll')
WHERE thread.pollid = poll.pollid AND poll.active = '1' AND dlog_t.primaryid IS NULL AND dlog_p.primaryid IS NULL
ORDER BY poll.dateline ASC LIMIT 10");

[Fargo]

any chance you got your problem figured out, Lionel? Im doing something similar (actually, just a test by returning all forum titles), but its only returning the first row.

[Lionel]

Originally Posted by Fargo

any chance you got your problem figured out, Lionel? Im doing something similar (actually, just a test by returning all forum titles), but its only returning the first row.

are you trying to get a list of all polls?