[arracing]

its still showing closed polls for some reason i tried using both !=0 and =1 and they both dont work. I also tried with and without the '1' around the 1.

here is my code:

$pollinfo=$DB_site->query_first("SELECT thread.pollid, thread.open, thread.threadid, thread.replycount, poll.pollid, poll.question, poll.dateline, poll.options, poll.votes, poll.active, poll.numberoptions, poll.timeout, poll.multiple, poll.voters FROM thread LEFT JOIN poll ON (thread.pollid=poll.pollid) WHERE thread.pollid!='0' AND thread.open='1' AND thread.open<>10 AND poll.active='1' AND thread.forumid!=64 AND thread.forumid!=49 AND thread.forumid!=47 AND thread.forumid!=40 ORDER BY RAND()");