mySQL query not returning correct results!

Question

This query that I have is returning therapists whose 'therapistTable.activated' is equal to false as well as those set to true! so it's basically selecting all of the db, any advice would be appreciated!

`           $query = "SELECT
                 therapistTable.*
                 FROM
                 therapistTable
                 WHERE
                 therapistTable.activated = 'true'
                 ORDER BY 
                 therapistTable.distance
                 ";              
`

Pete: In your question, please provide the output of the following SHOW CREATE TABLE therapistTable — hobodave
– hobodave, Commented Mar 19, 2010 at 23:36

TehShrike · Accepted Answer · 2010-03-19 23:35:57Z

1

What is the column type of the column activated, and what are some sample values from the table?

Is it perhaps a BOOL, or some other integer value? 'true' is a string - TRUE is an integer.

If therapistTable.activated is a BOOL, you will want to compare it to TRUE instead of a string.

answered Mar 19, 2010 at 23:35

TehShrike

10.1k2 gold badges36 silver badges28 bronze badges

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

5 Comments

Doug Molineux Over a year ago

its actually a varchar with a string, but i'll change it to a boolean and try that

TehShrike Over a year ago

Oh hey, don't go doing that on a whim - nothing wrong with storing string values. What are some sample values from the table?

Doug Molineux Over a year ago

k it didn't work, i turned it back to a varchar i use navicat to set the value of therapistTable.activated to true or false no quotes or anything just that,

Doug Molineux Over a year ago

interestingly when i run the same query through navicat it worked properly

Doug Molineux Over a year ago

i got it i apologize turns out that wasnt the query being sent, the query runs perfectly well like ` $query = "SELECT therapistTable.* FROM therapistTable WHERE therapistTable.activated = 'true' ORDER BY therapistTable.distance "; `

Brendan Long · Accepted Answer · 2010-03-19 23:33:51Z

0

If you're using a boolean type, you should be using TRUE and not'true'. I don't know how that would cause your problem though..

Just to explain: TRUE is an integer (equal to 1), but 'true' is a string.

answered Mar 19, 2010 at 23:33

Brendan Long

54.6k21 gold badges154 silver badges194 bronze badges

Comments

Doug Molineux · Accepted Answer · 2010-03-20 00:09:01Z

0

$query = "SELECT therapistTable.* FROM therapistTable WHERE therapistTable.activated = 'true' ORDER BY therapistTable.distance ";

is correct

answered Mar 20, 2010 at 0:09

Doug Molineux

12.5k26 gold badges96 silver badges144 bronze badges

Collectives™ on Stack Overflow

mySQL query not returning correct results!

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related