note 98313 added to function.odbc-tables

Hello folks, Most interesting posts were: iggvopvantoodlwin (01-Mar-2004 03:42) and liquidicee at hotmail dot com (11-Mar-2001 04:02) Combining them i came to this: ____________________begin________________________ $result = odbc_tables($link); //odbc_result_all(odbc_tables($link)); //listeaza tot din baza de date tabele, view-uri etc, e foarte utila. while (odbc_fetch_row($result)) { switch(odbc_result($result, 4)) { case "TABLE": echo "<BR>".odbc_result($result, 3); break; case "VIEW": echo "<BR>".odbc_result($result, 3); break; case "SYNONYM": echo "<BR>".odbc_result($result, 3); break; } } _____________________end________________________ Basicly from the first post you can see all queries, lists from sharepoint, linked tables from your access database and you can see the type name. In my case i want all of them TABLE=access table, SYNONYM=linked table, VIEW=query. Good luck! ---- Server IP: 69.147.83.197 Probable Submitter: 188.26.41.177 ---- Manual Page -- http://www.php.net/manual/en/function.odbc-tables.php Edit -- https://master.php.net/note/edit/98313 Del: integrated -- https://master.php.net/note/delete/98313/integrated Del: useless -- https://master.php.net/note/delete/98313/useless Del: bad code -- https://master.php.net/note/delete/98313/bad+code Del: spam -- https://master.php.net/note/delete/98313/spam Del: non-english -- https://master.php.net/note/delete/98313/non-english Del: in docs -- https://master.php.net/note/delete/98313/in+docs Del: other reasons-- https://master.php.net/note/delete/98313 Reject -- https://master.php.net/note/reject/98313 Search -- https://master.php.net/manage/user-notes.php