note 62621 added to function.odbc-fetch-array
| From: | nauti at knusperleicht dot at | Date: | Sun, 05 Mar 2006 17:19:16 +0000 |
| Subject: | note 62621 added to function.odbc-fetch-array | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-104852@lists.php.net to get a copy of this message | ||
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);
}
}
----
Server IP: 80.78.242.21
Probable Submitter: 62.47.145.195
----
X-Spam-Status: No, hits=3.3 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER,
HTML_MESSAGE autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/function.odbc-fetch-array.php
Edit -- http://master.php.net/note/edit/62621
Del: integrated -- http://master.php.net/note/delete/62621/integrated
Del: useless -- http://master.php.net/note/delete/62621/useless
Del: bad code -- http://master.php.net/note/delete/62621/bad+code
Del: spam -- http://master.php.net/note/delete/62621/spam
Del: non-english -- http://master.php.net/note/delete/62621/non-english
Del: in docs -- http://master.php.net/note/delete/62621/in+docs
Del: other reasons-- http://master.php.net/note/delete/62621
Reject -- http://master.php.net/note/reject/62621
Search -- http://master.php.net/manage/user-notes.php