|   | php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
| 
 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits              [2008-11-30 02:26 UTC] a dot collins at qub dot ac dot uk
  [2008-12-01 09:10 UTC] grant dot croker at ingres dot com
  [2008-12-01 09:44 UTC] a dot collins at qub dot ac dot uk
  [2008-12-01 11:08 UTC] grant dot croker at ingres dot com
  [2008-12-01 12:08 UTC] a dot collins at qub dot ac dot uk
  [2008-12-02 04:03 UTC] grant dot croker at ingres dot com
  [2008-12-02 04:04 UTC] grant dot croker at ingres dot com
 | |||||||||||||||||||||||||||
|  Copyright © 2001-2025 The PHP Group All rights reserved. | Last updated: Fri Oct 31 04:00:01 2025 UTC | 
Description: ------------ If a query has no characters preceding the word 'SELECT' at the start, the query will fail. Introducing a space or new line character befor 'SELECT' clears the fault. Apache 2.2.10 PHP 5.2.6 ./configure \ --prefix=/usr/local/apache/php \ --with-apxs2=/usr/local/apache/bin/apxs \ --with-config-file-path=/usr/local/apache/conf else ./configure \ --disable-cgi \ --disable-debug \ --enable-magic-quotes \ --enable-bcmath \ --enable-mbstring \ --enable-mbstr-enc-trans \ --enable-ingres \ --prefix=/usr/local/apache/php \ --with-apxs2=/usr/local/apache/bin/apxs \ --with-config-file-path=/usr/local/apache/conf \ --with-gdbm \ --with-gettext \ --with-ldap \ --with-mssql=/usr/local/freetds \ --with-mysql=/usr/local/mysql \ --with-oci8=instantclient,/usr/local/oci8 \ --with-zlib-dir=/usr/lib \ --with-pear php.ini modfications to default ------------------------ error_reporting = E_ALL display_errors = On user_dir = /www/infoserve include_path = ".:/usr/local/apache/php/lib/php" extension_dir = "/usr/local/lib/php/extensions/" extension=dbg-php-5.2.so extension=ingres.so extension=pdf.so session_name = QUBSESSID session.cookie_domain = ".qub.ac.uk" session.hash_bits_per_character = 5 [debugger] ; added by Alan Collins (see extension=dbg above) debugger.enabled=on debugger.profiler_enabled=on debugger.hosts_allow=localhost, 127.0.0.1, 143.117.14.72, 143.117.17. 143.117.3.66 debugger.hosts_deny=ALL debugger.ports=7869 10000/16 Reproduce code: --------------- <?php $database='strule::sislive'; $user=''; $password=''; $conn = ingres_connect($database,$user,$password); if ($conn) { echo "Connection succeeded."; // following query fails $sql = "select relowner from iirelation where relid='iirelation'"; // this works // $sql = " select relowner from iirelation where relid='iirelation'"; $rc=ingres_query($conn,$sql); if ($rc) { echo "Query succeeded."; while ($row=ingres_fetch_row($rc)) { echo $row[1]; } } else { echo "Query failed."; } ingres_close($conn); } else { echo "Connection failed."; } Expected result: ---------------- Connection succeeded.Query succeeded.$ingres Actual result: -------------- Connection succeeded.Query failed.