how can i get a table array of a database

[yindu]

hello,sir;
  i do know i can use "show tables" to get the table names list.but i need get a table 
name
array to use in my application.like the array
i get by "select" function .
how can i do it?thank you!
                                yin du