Posted by malcolm on 02/28/06 02:14

On Mon, 27 Feb 2006 17:29:51 -0500, J.O. Aho <user@example.net> wrote:

> malcolm wrote:
>> Hello All,
>> On my rented space I have only one database. I have a few users at
>> my site
>> and any mysql tables I made for them have their initials as a prefix
>> i.e.
>> aa_phonelist, aa_addresses, aa_otherjunk
>> bb_phonelist, bb_addresses, bb_otherjunk
>> I want to make a drop down selection for the tables so that each can
>> see his/her tables
>> but ONLY theirs. What I really want is a query like 'Show tables where
>> prefix like aa_'
>> and send the results to the drop down. Obviously that won't work but
>> I have wracked my
>> small brain for quite some time now and can't seem to find something
>> that will work.
>> I have tried to use the show table results with things like in_array
>> but I just can't
>> make it work. This is on a logged-in page so I know the prefix but I
>> can't seem to limit
>> show tables at all and I can't find a way to strip out the other
>> prefixes from the resulting
>> array. Not zillions but quite a few tables and new ones all the time,
>> so this needs to be
>> dynamic.
>
> Look at the mysql_list_tables() function, if you aren't using mysql on
> the host, then it will be more tricky. If you use the function, then you
> will need to filter the result when you got it to PHP, while the
> alternative options could work with WHERE statements.
>
> http://www.php.net/manual/en/function.mysql-list-tables.php
>
>
> //Aho


Thanks Aho but I'm able to list the tables ok and do the drop down but
I can't figure how to filter the array returned by the 'show tables' query.
That function does the same but I don't see any way there to filter the
result. I'm looking at array_clean now, thanks for reply.

[Back to original message]