Getting name of new of view from MySQL 5.0+

[ChronoFish]

Hello,

We are using MySQL 5.0+ because it now supports views. However it
appears that the PHP's(4.3) mysql_field_tab le() is returning a
temporary name table name rather than the actual table (view) name.

For instance we have a view defined as "open_meeetings _view", yet when
we do a mysql_field_tab le() the name retrieved is "#sql_7a3a_ 1". The
same call correctly retrieves all static tables and even aliases
correctly.

It does not appear that PHP has the ability to dig any deeper (maybe in
PHP 5.0?), but does anyone know how to query MySQL for this information
directly? A "show tables" does show the view names correctly. So we
just need a way to correlate the temporary table "#sql_7a3a_ 1" back to
the real view name "open_meeetings _view".

Any help would be greatly appreciated.

Thanks!
CF