Re: select question
| From: | Steve Werby | Date: | Tue, 17 Apr 2001 23:59:25 +0000 |
| Subject: | Re: select question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49087@lists.php.net to get a copy of this message | ||
"Matt "TrollBoy" Wiseman" <trollboy@shoggoth.net> wrote:
> How would I word a query to see what tables exist in a db that begin with
> box
>
> for example include
> boxTABLE1
> boxTABLE2
> boxTABLE3
> but exclude
> sphereTABLE1
>
> I'm basically trying lo populate a list box with the tables beginning with
> box in PHP.
Use the SHOW TABLES command within PHP and loop through the results and grab
those that match your criteria. Or use PHP directory functions (readdir and
associated functions) or a system ls function within backticks (like `ls -1
$prefix*`) to read the files within the directory containing the database.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/