"Matt "TrollBoy" Wiseman" <[EMAIL PROTECTED]> 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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
