PHP echo MySQL value in If/Else

Question

I have a PHP echo value that displays a value from a MySQL database like this:

<?php echo($row_WADAHTG_TechProps["EmpType"]); ?>

I need to construct an if/else with this value but am getting a syntax error no matter how I try to arrange this:

<?php
if (echo($row_WADAHTG_TechProps["EmpType"]) = "6001") {
  echo "Have a good day!";
} else {
  echo "Have a good night!";
}
?>

echo_Me · Accepted Answer · 2014-06-19 16:47:22Z

2

try that:

 <?php
      if ($row_WADAHTG_TechProps["EmpType"] == "6001") {
             echo "Have a good day!";
      } else {
             echo "Have a good night!";
      }
 ?>

answered Jun 19, 2014 at 16:47

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

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

4 Comments

Jack Over a year ago

+1, but why aren't you using the strict comparison operator (i.e ===)?

echo_Me Over a year ago

@JackWilliam === is used for checking the equality as well as type.

echo_Me Over a year ago

6001 can maybe a integer or string . so it will be true in both. but with === it will just accept same type.

Jack Over a year ago

You're right, but I presumed he was expecting it as a string. It depends on the OP's app.

brechmos · Accepted Answer · 2014-06-19 16:47:56Z

1

if ( $row_WADAHTG_TechProps["EmpType"] == "6001") {
   echo "Have a good day!";
 } else {
   echo "Have a good night!";
 }

Careful with the single '=' sign in the if statement as that is an assignment.

answered Jun 19, 2014 at 16:47

brechmos

1,3161 gold badge11 silver badges22 bronze badges

Comments

Chris · Accepted Answer · 2014-06-19 16:49:36Z

1

what about

<?php
    if ($row_WADAHTG_TechProps["EmpType"] == "6001") {
        echo "Have a good day!";
    } else {
        echo "Have a good night!";
    }
?>

you have to compare a value with ==or === (if you also want to compare the type)

answered Jun 19, 2014 at 16:49

Chris

337 bronze badges

Comments

Jack · Accepted Answer · 2014-06-19 17:01:15Z

1

I use shorthand ternary operators for if/else conditions

($row_WADAHTG_TechProps["EmpType"] === "6001" ? echo "Yes" : echo "No");

Notice I'm strictly comparing $row_WADAHTG_TechProps["EmpType"] to "6001" as strings, therefore if either of them are integers, the condition will echo "No".

edited Jun 19, 2014 at 17:01

answered Jun 19, 2014 at 16:55

Jack

1,9411 gold badge19 silver badges33 bronze badges

Collectives™ on Stack Overflow

PHP echo MySQL value in If/Else

4 Answers 4

4 Comments

Comments

Comments

I use shorthand ternary operators for if/else conditions

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

I use shorthand ternary operators for if/else conditions

Comments

Your Answer

Sign up or log in

Post as a guest

Related