Re: odbc_tables()

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@lists.php.net >For additional commands, e-mail: php-general-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >