SELECT syntax
| From: | Ron Piggott | Date: | Wed, 12 Oct 2011 19:24:44 +0000 |
| Subject: | SELECT syntax | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-48037@lists.php.net to get a copy of this message | ||
In my Bible_Trivia table I have the columns
trivia_answer_1, trivia_answer_2, trivia_answer_3,
trivia_answer_4, answer
answer is an integer always with a value of 1 to 4. Is there a way to use the value of
answer to only select the correct trivia answer?
This doesn’t work, but this is the idea I am trying to achieve:
SELECT trivia_answer_answer` FROM Bible_trivia`
Thanks in advance,
Ron
www.TheVerseOfTheDay.info