#22852 [Opn->Fbk]: Results returned by odbc_exec are not right

From: Date: Tue, 25 Mar 2003 01:19:55 +0000
Subject: #22852 [Opn->Fbk]: Results returned by odbc_exec are not right
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-36358@lists.php.net to get a copy of this message 
 ID:               22852
 Updated by:       sniper@php.net
 Reported By:      craig at myschoolmates dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         ODBC related
 Operating System: Win XP Pro
 PHP Version:      4.3.1
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip


Previous Comments:
------------------------------------------------------------------------

[2003-03-24 10:38:11] craig at myschoolmates dot com

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 this bug report at http://bugs.php.net/?id=22852&edit=1

Thread (3 messages)

« previous php.bugs (#36358) next »