SQL (nette) returning weird number of rows

Asked May 31 '20 at 23:30

Active May 31 '20 at 23:30

Viewed 74 times

I have a query in PHP framework nette... it looks like this

$result = $db->query("SELECT * FROM table")->fetchAll(); //count($result) = 20874;

But then I do this for testing purposes:

$result = $db->query("SELECT * FROM table WHERE value = '123'")->fetchAll(); //count($result) = 12;
$result = $db->query("SELECT * FROM table WHERE value <> '123'")->fetchAll(); //count($result) = 20874;

The problem is, when I iterate through $result from first classic query like this

foreach($result as $r){
    if($value == "123"){
         print_r("I FOUND HIM");die();
    }
}

It never "finds him". I mean the rows are obviously there, but aren't in query results without condition. Is it possible, that there is any limit? Thanks

asked May 31 '20 at 23:30

Štěpán Chvatík

What is the datatype of column `value`? – GMB May 31 '20 at 23:31
It is varchar(20) – Štěpán Chvatík May 31 '20 at 23:33
These results make no sense. If you have `20874` rows total, how can `WHERE value <> '123'` return the same number of rows, while `WHERE value = '123'` returns `12` rows? – GMB May 31 '20 at 23:34
You could inspect the results of the `WHERE value = '123'` query and see what they contain. – GMB May 31 '20 at 23:36
Exactly. That's why I am getting confused. Tried whole query in phpmyadmin, same nubmers. – Štěpán Chvatík May 31 '20 at 23:37
Rows are the same... It looks like that WHEN I DONT SPECIFY value='123' it doesn't iclude rows in result. But I do not know why – Štěpán Chvatík May 31 '20 at 23:42

SQL (nette) returning weird number of rows

0 Answers0