note 27586 added to function.odbc-tables
| From: | kthejoker at nospam dot hotmail dot com | Date: | Thu, 12 Dec 2002 04:29:05 +0000 |
| Subject: | note 27586 added to function.odbc-tables | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-40780@lists.php.net to get a copy of this message | ||
A bit of an extension on the previous posts:
I had a whale of a time trying to make this command work .. the parameters were hard to decipher,
and frequently my Apache module would just crash and burn when I tried to run it. I FINALLY figured
out what was wrong ...
< -- assuming $conn is your odbc_connect --->
$tablelist=odbc_tables($conn);
$tablelist=odbc_result_all($tablelist);
simply doesn't work. I don't understand the exact logistics of it, but the only way I
could get it to post the results was this:
$tablelist=odbc_result_all(odbc_tables($conn));
From there it was rather simple to add in parameters that fished out the results I wanted.
To repeat again: I do not understand why the 2nd method works and the 1st one does not. However,
having struggled mightily with this function for almost 24 hours, posting this solution has proven
to be greatly satisfying.
--
http://www.php.net/manual/en/function.odbc-tables.php
http://master.php.net/manage/user-notes.php?action=edit+27586
http://master.php.net/manage/user-notes.php?action=delete+27586
http://master.php.net/manage/user-notes.php?action=reject+27586