#49256 [Com]: PHP ignores Where clause on Where with boolean fields

[selotsom at hotmail dot com]

 ID:   49256
 Comment by:   selotsom at hotmail dot com
 Reported By:  rafinguer at gmail dot com
 Status:   Open
 Bug Type: PostgreSQL related
 Operating System: Windows Vista
 PHP Version:  5.2SVN-2009-08-14 (snap)
 New Comment:

I use postgre and php, and I have not any problem. I also use logical
deletions with a boolean field, and it works well.

Please, send me your code and the database model at
selot...@hotmail.com


Previous Comments:


[2009-08-15 09:30:33] rafinguer at yahoo dot es

I'm sorry. The code is not correct. The code is the next following:

$result=;
$qry = select id_product_type, name_product_type .
   from sch_trazalogic.product_type .
   where deleted=false .
   order by name_product_type;
$result_qry = pg_query($connection, $qry);
$num_rows = pg_numrows($result_qry);
$current=0;
while ($current$num_rows) {
  $row = pg_fetch_row($result_qry, $current);  // fetch current row
  $result = $result.$row[0].-.$row[1].\n;
  $current++;
}
pg_close($connection);
echo $result;

Apache version is 2.2



[2009-08-15 09:25:55] rafinguer at yahoo dot es

I forgot to mention that the version of PostgreSQL is 8.3



[2009-08-14 16:07:01] rafinguer at gmail dot com

Description:

PHP ignores the true or false values in a SQL sentence, returning
always  
all the records:

select id_product_type, name_product_type 
from sch_trazalogic.product_type 
where deleted=false
order by name_product_type

I tried with where deleted='f' and with where not deleted. The 
result is the same. With PGAdmin (Query tool), the result is correct.

Reproduce code:
---
$result=;
$qry = select id_product_type, name_product_type .
   from sch_trazalogic.product_type .
   where deleted=false .
   order by name_product_type;
$result_qry = pg_query($connection, $qry);
$num_rows = pg_numrows($result_qry);
$current=0;
while ($current$num_rows) {
  $row = pg_fetch_row($result_qry, $current);  // fetch current row
  $result = $result_xml.$row[0].-.$row[1].\n;
  $current++;
}
pg_close($connection);
echo $result_xml;


Expected result:

All the records with deleted with false value

Actual result:
--
All the records (deleted=true and deleted=false)





-- 
Edit this bug report at http://bugs.php.net/?id=49256edit=1

#49256 [Com]: PHP ignores Where clause on Where with boolean fields

[rafinguer at yahoo dot es]

 ID:   49256
 Comment by:   rafinguer at yahoo dot es
 Reported By:  rafinguer at gmail dot com
 Status:   Open
 Bug Type: PostgreSQL related
 Operating System: Windows Vista
 PHP Version:  5.2SVN-2009-08-14 (snap)
 New Comment:

I forgot to mention that the version of PostgreSQL is 8.3


Previous Comments:


[2009-08-14 16:07:01] rafinguer at gmail dot com

Description:

PHP ignores the true or false values in a SQL sentence, returning
always  
all the records:

select id_product_type, name_product_type 
from sch_trazalogic.product_type 
where deleted=false
order by name_product_type

I tried with where deleted='f' and with where not deleted. The 
result is the same. With PGAdmin (Query tool), the result is correct.

Reproduce code:
---
$result=;
$qry = select id_product_type, name_product_type .
   from sch_trazalogic.product_type .
   where deleted=false .
   order by name_product_type;
$result_qry = pg_query($connection, $qry);
$num_rows = pg_numrows($result_qry);
$current=0;
while ($current$num_rows) {
  $row = pg_fetch_row($result_qry, $current);  // fetch current row
  $result = $result_xml.$row[0].-.$row[1].\n;
  $current++;
}
pg_close($connection);
echo $result_xml;


Expected result:

All the records with deleted with false value

Actual result:
--
All the records (deleted=true and deleted=false)





-- 
Edit this bug report at http://bugs.php.net/?id=49256edit=1

#49256 [Com]: PHP ignores Where clause on Where with boolean fields

[rafinguer at yahoo dot es]

 ID:   49256
 Comment by:   rafinguer at yahoo dot es
 Reported By:  rafinguer at gmail dot com
 Status:   Open
 Bug Type: PostgreSQL related
 Operating System: Windows Vista
 PHP Version:  5.2SVN-2009-08-14 (snap)
 New Comment:

I'm sorry. The code is not correct. The code is the next following:

$result=;
$qry = select id_product_type, name_product_type .
   from sch_trazalogic.product_type .
   where deleted=false .
   order by name_product_type;
$result_qry = pg_query($connection, $qry);
$num_rows = pg_numrows($result_qry);
$current=0;
while ($current$num_rows) {
  $row = pg_fetch_row($result_qry, $current);  // fetch current row
  $result = $result.$row[0].-.$row[1].\n;
  $current++;
}
pg_close($connection);
echo $result;

Apache version is 2.2


Previous Comments:


[2009-08-15 09:25:55] rafinguer at yahoo dot es

I forgot to mention that the version of PostgreSQL is 8.3



[2009-08-14 16:07:01] rafinguer at gmail dot com

Description:

PHP ignores the true or false values in a SQL sentence, returning
always  
all the records:

select id_product_type, name_product_type 
from sch_trazalogic.product_type 
where deleted=false
order by name_product_type

I tried with where deleted='f' and with where not deleted. The 
result is the same. With PGAdmin (Query tool), the result is correct.

Reproduce code:
---
$result=;
$qry = select id_product_type, name_product_type .
   from sch_trazalogic.product_type .
   where deleted=false .
   order by name_product_type;
$result_qry = pg_query($connection, $qry);
$num_rows = pg_numrows($result_qry);
$current=0;
while ($current$num_rows) {
  $row = pg_fetch_row($result_qry, $current);  // fetch current row
  $result = $result_xml.$row[0].-.$row[1].\n;
  $current++;
}
pg_close($connection);
echo $result_xml;


Expected result:

All the records with deleted with false value

Actual result:
--
All the records (deleted=true and deleted=false)





-- 
Edit this bug report at http://bugs.php.net/?id=49256edit=1