php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #22852 Results returned by odbc_exec are not right
Submitted: 2003-03-24 10:38 UTC Modified: 2003-03-31 01:59 UTC
From: craig at myschoolmates dot com Assigned:
Status: No Feedback Package: ODBC related
PHP Version: 4.3.1 OS: Win XP Pro
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: craig at myschoolmates dot com
New email:
PHP Version: OS:

 

 [2003-03-24 10:38 UTC] 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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-03-31 01:59 UTC] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.


 
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Tue Dec 01 15:01:34 2020 UTC