mysql_list_tables

nigelbashford

I hope someone can help me out with this one. I know that mysql_list_tables returns ALL the names of the tables listed within the db, but how do return ONLY the tables I want?

As an example, say I have ten tables in my db of which only 5 correspond to the script I'm using. Also I can add and delete tables when ever, but only the table names that correspond to the script should be displayed. Is there anyway of indexing the tables so only those table names and those table names alone can be called by the script?

Any help on this would be great cos it's driving me nuts

nnichols

You could prepend a prefix to the table names and then you could use a query instead of mysql_list_tables -

SHOW tables FROM db_name LIKE 'prefix%'

Hope this helps 😉

nigelbashford

Hi nnichols,

Thanks, I hadn't considered that, but yes that's one way around the problem.. My only concern is others will be using the script and I'm not sure about the professionalism of the layout. If the decide to choose a name like Steve for their table and it comes out looking like _Steve or something similar it might look a little bit bad.....

If there's another way around it it would be better....I'll just keep on hacking...but if all else fails I'll use the SHOW table....

Thanks again for you help