If checkbox checked after using find()

[rooofl]

I try to display all the pages `news` with a checkbox `show_in_slide` unchecked.

Here is my code:

$news_list = $pages->find("template=news, sort=name, show_in_slide=0");
if ($news_list) {
    echo "There is at least one news not shown in slide";
}else{
    echo "No news";
}

This works if I have such a news, but “There is at least one news not shown in slide” appears also if it is not the case. What I am doing wrong?

Edited August 8, 2015 by rooofl

[Raymond Geerts]

try

show_in_slide!=1

If i recall correctly the checkbox has no default value of 0 so it could be empty

[Macrura]

or even

show_in_slide=

(?)

[Raymond Geerts]

Well,

show_in_slide=

will miss the ones that have value 0

while

show_in_slide=0

will miss the ones that have no value

but

show_in_slide!=1

will fetch all that are empty and those with value 0 (or anything that has not value 1 for that matter)

@rooofl i like your avatar, you realy wrapped your head around it

[rooofl]

Thank you for your quick replied, but none of the solutions seams to work.

Let me correct my first post: In the case the condition should display “no news”, it displays “There is at least one news not shown in slide”, and not nothing as I wrote before. Sorry for this confusion.

[rooofl]

I still have trouble to find how to solve this issue, can anyone help me?

[LostKobrakai]

Your problem isn't the selector, but the if condition. $news_list is an object of the class PageArray. Objects always equal true in php. You need to check if there are entries in that object. 

$news_list = $pages->find("template=news, sort=name, show_in_slide!=1");

if ($news_list->count()) {
    echo "There is at least one news not shown in slide";
}else{
    echo "All news items are shown in the slide";
}

[rooofl]

Thank you LostKobrakai, it works perfectly by testing count(), my final code is:

$news_list = $pages->find("template=news, sort=name, show_in_slide!=1");

if ($news_list->count()) {
    echo "There is at least one news not shown in slide";
}else{
    echo "All news items are shown in the slide";
}