I have a php form that asks a question and when submitted will store the question in a MySql table called ‘questions’.
I have another php form where an answer can be posted to that question and is stored in same table as the question.
How would I display all of the questions - those with answers and those without answers on a seperate page where the answer is beneath the question.
In the table I have the folowing fields
Below is an example of how I would like the display to look. Some questions may not have answers while others will.
Q1: How big is the car?
Q1Answer: It is 5 meters from bumper to bumper.
Q2: What color is the dog?
Q3 Will it rain today?
Q3Answer: Only if there are clouds in the sky.
Q4: Who is on first?
Q5: What time is it?
Q6: Do you have ice cream?
Q6Answer: We have chocolate and vanillia.
I have a basic idea on how to do this but am not sure of how to write the code for it. The idea would go something like this:
Check database for questions
—if there are questions
--------check database for answer to question
-----------if question has answer
-----------else print blank line
—else print blank line
If someone could give me hand writing the php for this I would be eternally indebted to them. (I’m a poor fellow and am already eternally in debt to many not the least of which is the bank LoL, but you will also have my eternal gratitude too. )