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=49256&edit=1