odbc_tables problem..
| From: | Serdar Soydemir | Date: | Mon, 07 Aug 2000 20:39:20 +0000 |
| Subject: | odbc_tables problem.. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1837@lists.php.net to get a copy of this message | ||
Hi,
I'm having problems with some ODBC functions, i'm trying to fetch a list of
tables in a data source with "odbc_tables" command, but directives in manual
aren't enough to let me get what i want. I just want to get all TABLE's (not
SYSTEM TABLE or VIEW) table names and store them in an array.
When i use:
$cnx = odbc_connect( 'odbctest' , 'root', '' );
$tables = odbc_tables($cnx);
It allows only odbc_result_odbc: (with odbc_result i can see only first row)
odbc_result_all($tables);
Manuals contains other properties for odbc_tables like;
$tables = odbc_tables($cnx,"%","","","");
but any of the combinations doesn't give what i want, table names.
Has anyone user odbc_tables before and can give me an exemple?
Thank you very much.
--
Serdar
www.php.org.tr