Re: [PHP-DB] Advice on searching multiple tables.. From: Alexey Borzov (borz_off <email protected>)
Date: 08/14/00

Greetings, Chad!

    Urgh...
    This sounds like we have a REALLY S**TTY database design here...
Can you be a lil' more specific about what do you store in this tables
and why the hell you have to search ALL OF THEM?

At 14.08.2000, 10:54, you wrote:
CD> Looking for a good way to do this.. I can think of an ugly way, but it
CD> doesn't seem too efficient.

CD> I am getting one value from a form and I need to search multiple tables to
CD> see if this field matches.. the tricky part is I need to basically search
CD> all the columns in all the tables for this value, and the column names
CD> obviously aren't the same, and some tables have 5 columns, some have 15.

CD> The ugly way I can think of is just one damn long mysql query, but that
CD> seems like it would be REALLY slow. The other way I can think of is doing X
CD> # of searches, where X is the number of tables.. so if I had 5, do 5
CD> different searches. 

-- 
Yours, Alexey V. Borzov, Webmaster of RDW

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>