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

ID: 22852 Updated by: sniper@php.net Reported By: craig at myschoolmates dot com -Status: Feedback +Status: No Feedback Bug Type: ODBC related Operating System: Win XP Pro PHP Version: 4.3.1 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [2003-03-24 19:19:53] sniper@php.net 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 ------------------------------------------------------------------------ [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