ID: 22852 Updated by: [EMAIL PROTECTED] 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
