note 62621 deleted from function.odbc-fetch-array by philip
| From: | philip@php.net | Date: | Sun, 21 Dec 2008 15:16:17 +0000 |
| Subject: | note 62621 deleted from function.odbc-fetch-array by philip | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-148422@lists.php.net to get a copy of this message | ||
Note Submitter: nauti at knusperleicht dot at
----
An easy possibility to use list() for requesting data by while-loop.
define('ODBC_DB_DSN', 'dbsys');
define('ODBC_DB_USR', '');
define('ODBC_DB_PWD', '');
function record($resId){
$mpResult = odbc_fetch_array($resId);
if(is_array($mpResult)) {
return array_values($mpResult);
}
return false;
}
$resLink = odbc_pconnect(ODBC_DB_DSN, ODBC_DB_USR, ODBC_DB_PWD);
if(is_resource($resLink)) {
$stQuery = "SELECT id, sort, name FROM category";
$resId = odbc_exec($resLink, $stQuery);
while(list($nID, $nSort, $stName) = record($resId)) {
echo $nID, " ", $nSort, " ", $stName;
echo "<br />\r\n";
}
if(is_resource($resId)) {
odbc_free_result($resId);
}
if(is_resource($resLink)) {
odbc_close($resLink);
}
}