hey guys. i need some help finding all the tables in a database that start with, lets say, db_ what function would i use to find this? i've been looking through the php docs and havnt really seen a function that will find tables. or at least dont know a good syntax to do it. thanks for any help!
use sql 'SHOW TABLES FROM [db_name] LIKE [wild];'
or function
$result = mysql_list_tables(tbl_name, wildcard);
They are both in the msysql manual. Type 'list tables' in the help search.
thanks! got it figured out!