PHP if statement problem

Question

I have a MySql database with the var 'mls', which either has an entry of 0 or 1.

I am trying to use an If statement to display text depending on the mls var.

The data is being pulled from the datbase ok becasue I can use an 'echo' to dispaly the entry of the 'mls'. The problem is it is just going straight to the else statement and showing the 'else' data, here is the code...

<? echo ucwords($res['mls']); ?>
   <? if ($res['mls']) == 0)){

    echo $lang['rental'];   
}else
echo $lang['purchase'];
    ?>

Any help would be great.

Any reason, why you're ucword-ing a number?

Linus Kleen
– Linus Kleen

2010-12-10 18:52:03 +00:00
Commented Dec 10, 2010 at 18:52 — Linus Kleen
– Linus Kleen, Commented Dec 10, 2010 at 18:52

Konerak · Accepted Answer · 2010-12-10 18:49:34Z

1

It goes to the else because your if is wrong (count the parentheses)

 <? if ($res['mls']) == 0)){

Does the same as

<? if (0){

Which is false.

Fix:

 <? if ($res['mls'] == 0){

But do count your parentheses else where in the code ;)

Complete correct code:

<? 
 echo ucwords($res['mls']);
 if ($res['mls'] == 0)){
  echo $lang['rental'];   
 }
 else {
  echo $lang['purchase'];
 }
?>

answered Dec 10, 2010 at 18:49

Konerak

39.8k13 gold badges102 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gumbo · Accepted Answer · 2010-12-10 18:50:27Z

0

There is a syntax error in this line:

<? if ($res['mls']) == 0)){
                  ^

The marked closing parenthesis is also the closing parenthesis of the if statement syntax. Remove it and also the closing parenthesis right behind the 0:

<? if ($res['mls'] == 0){

answered Dec 10, 2010 at 18:50

Gumbo

657k112 gold badges792 silver badges852 bronze badges

Comments

Sunandmoon · Accepted Answer · 2010-12-10 18:50:51Z

0

<? echo ucwords($res['mls']); ?>
<? if ($res['mls'] == 0){
    echo $lang['rental'];   
}else{
     echo $lang['purchase'];
?>

answered Dec 10, 2010 at 18:50

Sunandmoon

2972 gold badges4 silver badges9 bronze badges

Comments

elixireu · Accepted Answer · 2010-12-10 19:03:07Z

0

Many Thanks for your help, it was the closing parenthesis of the if statement syntax and also the closing parenthesis right behind the 0:

Its now working ...

<? echo ucwords($res['mls']); ?>
   <? if ($res['mls'] == 0){

    echo $lang['rental'];   
}else
echo $lang['purchase'];
    ?>

Thanks

answered Dec 10, 2010 at 19:03

elixireu

2753 silver badges15 bronze badges

Comments

Conner · Accepted Answer · 2012-08-18 01:27:29Z

0

You're missing a (

<? if ($res['mls'] == 0)){

edited Aug 18, 2012 at 1:27

Conner

31.3k8 gold badges55 silver badges75 bronze badges

answered Dec 10, 2010 at 18:51

Pradeep Singh

3,6323 gold badges33 silver badges42 bronze badges

Collectives™ on Stack Overflow

PHP if statement problem

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Related