Show text only if rows in MySQL database equal 1

Question

How would I get some text to display only if certain rows equal 1. I have a table and there are I have fields labeled 'SEC1', 'SEC2', and 'SEC3'. I can get it to display text for just one equaling to one, but I want something were the fields above have to equal one in order for the text to show.

Any help is appreciated

This is what I am using to get it to work for one:

$Completed = ($row["SEC1"] == 1) ? "Completed!" : $row[""]; echo $Completed;

Is it possible to modify that to get it to work? I'd be fine with having them added together to equal 3 instead of one.

Did you skip the "Operators" section of your tutorial?

Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams

2011-06-12 04:40:35 +00:00
Commented Jun 12, 2011 at 4:40 — Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams, Commented Jun 12, 2011 at 4:40

Sparkup · Accepted Answer · 2011-06-12 04:58:39Z

1

If you mean that any of the three fields independently equals "1" then this will do it :

if (($row["SEC1"] == 1)||($row["SEC2"] == 1)||($row["SEC3"] == 1)){
//Do what you what
}

Or if you mean all three of them combined equal "3" then :

if (($row["SEC1"] + $row["SEC2"] + $row["SEC3"]) == 3){
//Do what you what
}

edited Jun 12, 2011 at 4:58

answered Jun 12, 2011 at 4:53

Sparkup

3,7522 gold badges38 silver badges50 bronze badges

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

1 Comment

user794477 Over a year ago

Thanks! I am a high school student and still trying to learn all of this.

dandrews · Accepted Answer · 2011-06-12 04:54:53Z

0

Why use the ternary operator? Use the 'and' operator to build more complex conditional statements:

$Completed = "";

if (($row["SEC1"] == 1) && ($row["SEC2"] == 1) && ($row["SEC3"] == 1)) {
    $Completed = "Completed!";
} 

echo $Completed;

There are a lot of different ways you could go about solving this

if ($row["SEC1"] + $row["SEC2"] + $row["SEC3"] == 3){
...
}

answered Jun 12, 2011 at 4:54

dandrews

3,0551 gold badge22 silver badges22 bronze badges

Collectives™ on Stack Overflow

Show text only if rows in MySQL database equal 1

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related