#22852 [NEW]: Results returned by odbc_exec are not right

From: Date: Mon, 24 Mar 2003 16:38:11 +0000
Subject: #22852 [NEW]: Results returned by odbc_exec are not right
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-36300@lists.php.net to get a copy of this message 
From:             craig at myschoolmates dot com
Operating system: Win XP Pro
PHP version:      4.3.1
PHP Bug Type:     ODBC related
Bug description:  Results returned by odbc_exec are not right

I have a standard php installation, latest 1.3 release on a win XP box,
using ODBC to access a Paradox database.

Connection code:

		$myDB = odbc_connect("llcs", "", "");
		$rs = odbc_exec($myDB, $Property_SQL);
		$count = 0;

To show Results, I use:

	  	while (odbc_fetch_into($rs, $my_array)) {
		  ?>
		  <tr>
		  	<td>
				<?php echo $my_array[0]; ?>
			</td>
                 ....

SQL Query example that works:

Select Firstname, Surname, Age from Users where Age=50

Returns alot of records, which is correct. I then take an example of a
record that I got back, eg: Craig, Lister, 50, and then try this SQL:

Select Firstname, Surname, Age from Users where Surname = "Lister"

That returns ONLY the first record. Eg, Andrew, Lister, 27

It seems to be only returning the first record when I search for strings,
but on numerical searches, it works fine.

You can see this at http://land.strand.serverbox.org
... use the
'Electoral Search'.

Thank you,
Craig
-- 
Edit bug report at http://bugs.php.net/?id=22852&edit=1
-- 
Try a CVS snapshot:         http://bugs.php.net/fix.php?id=22852&r=trysnapshot
Fixed in CVS:               http://bugs.php.net/fix.php?id=22852&r=fixedcvs
Fixed in release:           http://bugs.php.net/fix.php?id=22852&r=alreadyfixed
Need backtrace:             http://bugs.php.net/fix.php?id=22852&r=needtrace
Try newer version:          http://bugs.php.net/fix.php?id=22852&r=oldversion
Not developer issue:        http://bugs.php.net/fix.php?id=22852&r=support
Expected behavior:          http://bugs.php.net/fix.php?id=22852&r=notwrong
Not enough info:            http://bugs.php.net/fix.php?id=22852&r=notenoughinfo
Submitted twice:            http://bugs.php.net/fix.php?id=22852&r=submittedtwice
register_globals:           http://bugs.php.net/fix.php?id=22852&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=22852&r=php3
Daylight Savings:           http://bugs.php.net/fix.php?id=22852&r=dst
IIS Stability:              http://bugs.php.net/fix.php?id=22852&r=isapi
Install GNU Sed:            http://bugs.php.net/fix.php?id=22852&r=gnused

Thread (3 messages)

« previous php.bugs (#36300) next »