Re: [PHP] select question

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 > >

RE: [PHP] select question

On 17-Apr-01 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

Re: [PHP] select question

"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

[PHP] select question

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/troll