SELECTING using JOIN
Posted: Wed Aug 15, 2007 2:36 am
I have two tables,
1 question_table (will be entered by admin)
2 answer_table (will be entered by clients)
question_table
question_id
question
answer_table
member_id
question_id
I want to display all the questions which the members have not taken that question.
I tried using
i am getting from session of the login user
How to display the questions?
1 question_table (will be entered by admin)
2 answer_table (will be entered by clients)
question_table
question_id
question
answer_table
member_id
question_id
I want to display all the questions which the members have not taken that question.
I tried using
Code: Select all
"SELECT * FROM question_table, answer_table WHERE answer_table.member_id !=$memberID AND question_table.question_id !=answer_table.question_id";Code: Select all
$memberIDHow to display the questions?