[SOLVED] Single Line IF ELSE..?

[A JM]

I need some help with a single line IF ELSE statement - hopefully someone can help...

 

I was under the impression this would work but I'm not having any luck.

 

<?php $answ=$row_rstocdetail['pol_mortgage']=="y" ? "YES" : "NO"; ?>

 

Thanks.

 

A JM,

[MadTechie]

<?php $answ = ($row_rstocdetail['pol_mortgage']=="y")?"YES":"NO"; ?>

 

EDIT: question.. What are you trying to do ?

[SetToLoki]

hehe just asked about same thing

 

you might find this topic usefull

[A JM]

I'm trying to set the value of a YES/NO Option from a recordset so that the end user can edit the field if needed.

 

Just reaching out for some solution... this didn't work.

 

<select size="1" name="pol_mortgage" tabindex="32" class="form-inputitem"></option>
<option value="<?php echo htmlentities($row_rstocdetail['mortgage'], ENT_COMPAT, 'utf-8'); ?>"><?php echo htmlentities($row_rstocdetail['mortgage'], ENT_COMPAT, 'utf-8'); ?></option>
<option value="Y">YES</option>
<option value="N">NO</option></select>

[MadTechie]

is the field 'pol_mortgage' or 'mortgage' ?

heres two options

<select size="1" name="pol_mortgage" tabindex="32" class="form-inputitem"></option>

<?php
if(strtolower($row_rstocdetail['pol_mortgage'])=="y")
{
echo "<option value=\"Y\" selected=\"selected\">YES</option>";
echo "<option value=\"N\">NO</option>";
}else{
echo "<option value=\"Y\">YES</option>";
echo "<option value=\"N\" selected=\"selected\">NO</option>";
}
?>
</select>

OR

<select size="1" name="pol_mortgage" tabindex="32" class="form-inputitem"></option>

<select size="1" name="pol_mortgage" tabindex="32" class="form-inputitem"></option>

<?php
$sel = (strtolower($row_rstocdetail['pol_mortgage'])=="y")
?>
<option value="Y" <?php echo ($sel)?"selected=\"selected\"":"";?>>YES</option>";
<option value="N" <?php echo (!$sel)?"selected=\"selected\"":"";?>>NO</option>";
</select>
?>

[A JM]

It also has an empty/null option.. is that feasible to add into that?

 

So there really no need for a single line - I see. Can you also perform a CASE statement similarly?

 

Thanks.

 

A JM,

 

 

[MadTechie]

It also has an empty/null option.. is that feasible to add into that?

Just add a blank one at the top

<option value=""></option>";

is neither are selected then its the default

 

So there really no need for a single line - I see. Can you also perform a CASE statement similarly?

 

You could do this in a case statement but its only 2 options this or that! so if seams better

of course you could do this

<option value="" <?php echo ($row_rstocdetail['pol_mortgage']="")?"selected=\"selected\"":"";?>></option>"
<option value="Y" <?php echo ($row_rstocdetail['pol_mortgage']="Y")?"selected=\"selected\"":"";?>>YES</option>";
<option value="N" <?php echo ($row_rstocdetail['pol_mortgage']="N")?"selected=\"selected\"":"";?>>NO</option>"
<option value="M" <?php echo ($row_rstocdetail['pol_mortgage']="M")?"selected=\"selected\"":"";?>>MayBe</option>"

[A JM]

Since the Option has a blank option the field in the DB can be ISNULL which when using the following gives me "NO" as opposed to a blank?

 

<option value="" <?php echo ($row_rstocdetail['pol_mortgage']="")?"selected=\"selected\"":"";?>></option>"
<option value="Y" <?php echo ($row_rstocdetail['pol_mortgage']="Y")?"selected=\"selected\"":"";?>>YES</option>";
<option value="N" <?php echo ($row_rstocdetail['pol_mortgage']="N")?"selected=\"selected\"":"";?>>NO</option>"
<option value="M" <?php echo ($row_rstocdetail['pol_mortgage']="M")?"selected=\"selected\"":"";?>>MayBe</option>"

 

Can I actually test for ISNULL and set the option to be blank?

 

Thanks.

 

A JM,