Re: [PHP-DB] SELECT syntax

[Karl DeSaulniers]

Heh,
Thanks Karthik. Not my post.. :)
But your solution looks dead on..

Here you go Ron. Try this one.

Best,
Karl


On Oct 13, 2011, at 2:42 AM, Karthik S wrote:


Try this,

select
CASE answer
 when 1 then trivia_answer_1
 when 2 then trivia_answer_2
 when 3 then trivia_answer_3
 when 4 then trivia_answer_4
END as trivia_answers
from bible_trivia_table

On Thu, Oct 13, 2011 at 1:02 PM, Karl DeSaulniers > wrote:

Or something like this?
SELECT * FROM `Bible_trivia` WHERE answer=`answer`;
Then match the results to trivia_answer_1 in php to see if correct.

if($trivia_answer_1 == $results) {
... do this
}

or a switch

switch ($results) {
   case $trivia_answer_1:
   ... do this
   case $trivia_answer_2
   ... do this

Best,
Karl


On Oct 12, 2011, at 11:04 PM, Amit Tandon wrote:

SELECT `trivia_answer_`answer`` FROM `Bible_trivia`

Karl DeSaulniers
Design Drumm
http://designdrumm.com



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Karl DeSaulniers
Design Drumm
http://designdrumm.com

Re: [PHP-DB] SELECT syntax

[Karl DeSaulniers]

Or something like this?
SELECT * FROM `Bible_trivia` WHERE answer=`answer`;
Then match the results to trivia_answer_1 in php to see if correct.

if($trivia_answer_1 == $results) {
... do this
}

or a switch

switch ($results) {
case $trivia_answer_1:
... do this
case $trivia_answer_2
... do this

Best,
Karl

On Oct 12, 2011, at 11:04 PM, Amit Tandon wrote:


SELECT `trivia_answer_`answer`` FROM `Bible_trivia`


Karl DeSaulniers
Design Drumm
http://designdrumm.com


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SELECT syntax

[Amit Tandon]

another 
example

regds
amit

"The difference between fiction and reality? Fiction has to make sense."


On Thu, Oct 13, 2011 at 9:34 AM, Amit Tandon  wrote:

> select 
> case 
> works in mysql also
> 
> regds
> amit
>
> "The difference between fiction and reality? Fiction has to make sense."
>
>
>
> On Thu, Oct 13, 2011 at 3:26 AM, Jack van Zanen  wrote:
>
>> Hi
>>
>> In Oracle (and maybe others) you can use
>>
>>
>> select case
>> when answer=1
>> then trivia_answer_1
>> when answer=2
>> then trivia_answer_2
>> when answer=3
>> then trivia_answer_3
>> when answer=4
>> then trivia_answer_4
>> else null
>> end answer
>> from bible_trivia_table
>> OR
>>
>> You can select all of them and process in PHP, should not be too hard to
>> come up with a couple of lines of code to display only 1 variable  based
>> on
>> the value of variable 5. Overhead should be pretty minimal as well
>> You'll be writing something to display a value anyway
>>
>>
>> Jack van Zanen
>>
>> -
>> This e-mail and any attachments may contain confidential material for the
>> sole use of the intended recipient. If you are not the intended recipient,
>> please be aware that any disclosure, copying, distribution or use of this
>> e-mail or any attachment is prohibited. If you have received this e-mail
>> in
>> error, please contact the sender and delete all copies.
>> Thank you for your cooperation
>>
>>
>> On Thu, Oct 13, 2011 at 6:24 AM, Ron Piggott <
>> ron.pigg...@actsministries.org
>> > wrote:
>>
>> >
>> > 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 
>> >
>>
>
>

Re: [PHP-DB] SELECT syntax

[Amit Tandon]

select case
works in mysql also

regds
amit

"The difference between fiction and reality? Fiction has to make sense."


On Thu, Oct 13, 2011 at 3:26 AM, Jack van Zanen  wrote:

> Hi
>
> In Oracle (and maybe others) you can use
>
>
> select case
> when answer=1
> then trivia_answer_1
> when answer=2
> then trivia_answer_2
> when answer=3
> then trivia_answer_3
> when answer=4
> then trivia_answer_4
> else null
> end answer
> from bible_trivia_table
> OR
>
> You can select all of them and process in PHP, should not be too hard to
> come up with a couple of lines of code to display only 1 variable  based on
> the value of variable 5. Overhead should be pretty minimal as well
> You'll be writing something to display a value anyway
>
>
> Jack van Zanen
>
> -
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>
>
> On Thu, Oct 13, 2011 at 6:24 AM, Ron Piggott <
> ron.pigg...@actsministries.org
> > wrote:
>
> >
> > 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 
> >
>

Re: [PHP-DB] SELECT syntax

[Jack van Zanen]

Hi

In Oracle (and maybe others) you can use


select case
when answer=1
then trivia_answer_1
when answer=2
then trivia_answer_2
when answer=3
then trivia_answer_3
when answer=4
then trivia_answer_4
else null
end answer
from bible_trivia_table
OR

You can select all of them and process in PHP, should not be too hard to
come up with a couple of lines of code to display only 1 variable  based on
the value of variable 5. Overhead should be pretty minimal as well
You'll be writing something to display a value anyway


Jack van Zanen

-
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation


On Thu, Oct 13, 2011 at 6:24 AM, Ron Piggott  wrote:

>
> 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 
>

RE: [PHP-DB] SELECT syntax

[Toby Hart Dyke]

Not terribly elegant, but this should work:

SELECT `trivia_answer_1` AS `trivia_answer` FROM `Bible_trivia` WHERE `answer`=1
UNION
SELECT `trivia_answer_2` AS `trivia_answer` FROM `Bible_trivia` WHERE `answer`=2
UNION
SELECT `trivia_answer_3` AS `trivia_answer` FROM `Bible_trivia` WHERE `answer`=3
UNION
SELECT `trivia_answer_4` AS `trivia_answer` FROM `Bible_trivia` WHERE 
`answer`=4;

I have to say that it's likely that your design may not be the most optimal. 
What happens if you want 5 answers? Or 6?

  Toby


-Original Message-
From: Ron Piggott [mailto:ron.pigg...@actsministries.org] 
Sent: Wednesday, October 12, 2011 3:25 PM
To: php-db@lists.php.net
Subject: [PHP-DB] SELECT syntax


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 


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php