Return 0 or 1 as 'Yes' or 'No'

Islefyord

Apologises if this has been asked before. I tried the search and struggled to find anything.

Basically I want to output a MySQL field to a table cell where the output is 'No' if the field is 0 and 'Yes' if the field is 1

Posting this from the office, but I can elaborate on filed types etc when i get home if you need me to.

Thanks

Isle

dalecosp

if ($var==0) { $var="No"; }
elseif ($var==1) { $var="Yes"; }

Islefyord

Doh....

Thank you 🙂

I had to ask someone how to close a html comment tag the other day, hmmm can I get a brain upgrade?

thanks again

dalecosp

Originally posted by Islefyord
I had to ask someone how to close a html comment tag the other day, hmmm can I get a brain upgrade?

If you figure this out, let us all know. A word of advice, though: don't get your upgrade from Micro$oft (or even RH Linux) 'cuz you'll be out of luck in a few years when the "life cycle" ends ... :eek: cue ominous music

Doh

Heh, we all do that sometimes... 😃

procoder

0 = false
1 = true

so this would work

if($var) then yes;
else then no;

if var is anything but 0 its a yes, if its 0 then its a no

stolzyboy

Originally posted by procoder
0 = false
1 = true

so this would work

if($var) then yes;
else then no;

if var is anything but 0 its a yes, if its 0 then its a no

day late and a dollar short 🙂

look up a few posts

stolzyboy

Originally posted by dalecosp
if ($var==0) { $var="No"; }
elseif ($var==1) { $var="Yes"; }
?? [/B]

this here was posted by dalecosp, a few posts before you did