odbc fetch array issues
| From: | Adil | Date: | Tue, 16 Nov 2004 21:38:01 +0000 |
| Subject: | odbc fetch array issues | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-202224@lists.php.net to get a copy of this message | ||
Hey people,
Anyone know much about odbc_fetch_array() or odbc_fetch_object() functions
in php. My while loop keeps breaking while using this function. I'm trying
to grab a row from the result returned by the database query and for testing
purposes, just printing out each item in the row as follows:
$sql = "SELECT * FROM users WHERE username='$username' AND
password='$password'";
$result = odbc_exec($dbConnection, $sql);
while ($rows = odbc_fetch_array($result)) { //This doesn't work with
odbc_fetch_object either
print $rows->COLUMNNAME;
}
I get nothing at all which I find pretty strange so I wanted to know if
there were any bugs with this function, maye while working on IIS or just
problems with the functions themselves.
Thx again
Adil.