In MySQL you can do this:
$sql = "SHOW TABLES LIKE 'box%'";
$r = mysql_query($sql);
// then loop through the tables and populate
--Joe
On Tue, Apr 17, 2001 at 07:49:11PM -0400, Matt TrollBoy Wiseman 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.
>
> Matt "Trollboy" Wiseman
> www.shoggoth.net/trollboy/trollboy.jpg
> [EMAIL PROTECTED]
> "I wish the world had one throat!!"
> -Al Bundy
>
> ---------------------------------------------------------
> Please do not resell my e-mail address
> to anyone or send me unsolicited e-mail
> ---------------------------------------------------------
>
>
> --
> 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]
/* Joe Stump
* Sr. PHP Developer
* http://www.Care2.com http://www.joestump.net http://gtk.php-coder.net
*/
--
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]