chackie
New Member
- Joined
- Nov 1, 2009
- Messages
- 87
- Reaction score
- 0
Shown in website browser
What no i need to type in SQL
A Database Error Occurred
Error Number: 1054
Unknown column 'p.question' in 'field list'
SELECT p.id, p.question, GROUP_CONCAT(a.answer SEPARATOR ';') AS answers, GROUP_CONCAT(a.id SEPARATOR ';') AS answers_id FROM poll p JOIN poll_answer a ON p.id = a.poll_id WHERE p.status = 1 AND date_start <= NOW() AND date_end >= NOW()
What no i need to type in SQL