Re: [PHP] odbc_tables() From: Frank M. Kromann (fmk <email protected>)
Date: 11/15/00

Hi,

I have no problems with the functio, but you need to understant the parameters ! Read my comments in the manual. http://www.php.net/manual/function.odbc-tables.php

If you want to do the same with a SQL statement (On MS SQL Server) you sould look at sysobjects.

select name from sysopjects where type='U'

returns the name of all user tables.

- Frank

>I'm sure that many of you have encountered a problem
>with odbc_tables. After calling this command it is possible
>to perform a odbc_result_all on it and the entire result is
>printed nicely however it is far more difficult to store this
>information into a variable. It's actually a bug, fetch_into_row
>and fetch_result both do not work.
>
>Has anyone found a work around to this ?
>
>Btw, does anyone know an SQL statement that will perform a
>"show tables" function or another way of querying an MSSQL
>database to retrieve the desired information ?
>
>Thanks very much !
>
>
>-- Matt
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-general-unsubscribe <email protected>
>For additional commands, e-mail: php-general-help <email protected>
>To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>