Mysqli select multiple from same row

Question

I have a question, I would like to make a query in mysqli.

I want to do this

 $sql = $db->query("SELECT * FROM padges WHERE enable ='1' AND enable='0'");

But it is not working. How do I solve this ?

You need to provide more detail. We are surely not a bunch of people looking through a crystal ball. — Daniel Cheung
– Daniel Cheung, Commented Oct 7, 2015 at 14:30

Your Common Sense · Accepted Answer · 2015-10-07 14:02:11Z

1

An enable ='1' AND enable='0' condition won't return any rows. Because database does search not the way you think it is. It will pick rows one by one, and test each against this condition. And obviously find no rows, as there couldn't be a row that's enabled and disabled at the same time. Instead you have to find rows that are either enabled or disabled:

SELECT * FROM padges WHERE enable ='1' OR enable='0'

Or, if 0 and 1 are the only values, you can omit WHERE clause at all

SELECT * FROM padges

answered Oct 7, 2015 at 14:02

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

Collectives™ on Stack Overflow

Mysqli select multiple from same row

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related