# Need php/mysql help

**URL:** <https://forum.kirupa.com/t/need-php-mysql-help/231462>\
**Category:** Uncategorized\
**Created:** [July 5, 2007, 1:52am UTC](https://forum.kirupa.com/t/need-php-mysql-help/231462 "2007-07-05T01:52:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ronnie482](https://avatars.discourse-cdn.com/v4/letter/r/839c29/32.png) [@ronnie482](https://forum.kirupa.com/u/ronnie482)\
**Post date:** [July 5, 2007, 1:52am UTC](https://forum.kirupa.com/t/need-php-mysql-help/231462/1 "2007-07-05T01:52:21Z")

</div>

I’ve 2 tables poll\_questions and poll\_answers. Each question has more than one answers. like question: do you smoke ? in poll\_answers table probable answers are like “Yes”, “No”, “No answer”.

I wanna display all questions and answers from both in order like

1. do you smoke ?  
ans:  
a. yes  
b. no  
c. don’t know

2. do you drink ?  
ans:  
a. yes  
b. No  
c. Don’t Know

I use select statement like  
SELECT \* FROM poll\_questions INNER JOIN poll\_answers on poll\_questions.id = poll\_answer.question\_id WHERE poll\_options.poll\_id=1;

I don’t know how can I loop or use proper SELECT statement. Please help. Thanks in advance.