Posted by Graham Cossey on 02/02/05 16:50

You don't say how many tables you have, how they are named or anything
outside of the query itself.

Assuming that not all your tables are named PID_* how about simply doing

SHOW TABLES LIKE '%PID_%'

and selecting appropriate results within the php script using strstr
or regular expressions? SHOW TABLES is (normally) such a quick query
returning a larger result set shouldn't be too much of a problem,
should it?

HTH

Graham

On Wed, 02 Feb 2005 15:15:38 +0100, Marek Kilimajer <lists@kilimajer.net> wrote:
> Shaun wrote:
> > Hi guys,
> >
> > Thanks for your replies but neither UNION or REGEXP can be used with SHOW
> > TABLES...
> >
> > Any ideas?
>
> It's time to change your table design. Use one pid table and add another
> column that would hold the number.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--
Graham

• Next in thread: Re: [PHP] Getting two queries into one result set
• Prev in thread: Re: [PHP] Getting two queries into one result set
• Next in forum: Re: [PHP] PHP Memory limit exceeded
• Prev in forum: Re: [PHP] Getting two queries into one result set
• Thread view: Re: [PHP] Getting two queries into one result set

[Reply to this message]