find unanswered question in mysql?

Question

hello, i am trying to modify random  question viewer plugin. But in that plug shows all question. i want to show unanswered random question. there is a query.

 function output_widget() {
        $random_question = qa_db_read_one_assoc(
            qa_db_query_sub('SELECT * FROM ^posts WHERE  type=$
            ORDER BY rand()
            LIMIT 1',
            'Q'),
                true );

how i can find unanswered question from mysql?

thank you.

Comments

Yeah I also want this

---

What's the repository link?

---

https://github.com/bluegenel/q2a-random-question
q2a-random-question.php line start from 42

Answer 1

Just replace this line:

qa_db_query_sub('SELECT * FROM ^posts WHERE  type=$

With this line:

qa_db_query_sub('SELECT * FROM ^posts WHERE  type=$ AND acount = 0

Comments

yeah. it is working. thank you @pupi1985