RE: [PHP-DB] re: Advice on searching multiple tables From: Chad Day (cday <email protected>)
Date: 08/14/00

The basic way this database is laid out is:

Table #1:

ID
TABLEPN
DESCRIPTION
QUANTITY
PRICE

where table part number is the name of the table.. if the table was named
xxx, the column would be XXXPN.

Some other tables have multiple part numbers, and look like:

Table #2

ID
TABLEPN
DESCRIPTION
ALTERNATETABLEPN #1
ALTERNATETABLEPN #2
QUANTITY

..

some have price, some don't, some have description, some don't, some have
quantity, etc etc etc.

Yes, it is really shoddy DB design, but re-designing 14 databases .. ugh..
especially when some of these tables have up to 15 alternate PN's. Is that
pretty much my only choice though?

Chad
-----Original Message-----
From: Terry Mehlman
To: php-db <email protected>
Sent: 8/14/00 7:38 AM
Subject: [PHP-DB] re: Advice on searching multiple tables

Any chance you can re-do the database design? It doesn't seem
particularly
suited to your uses as it stands.

Chad wrote:
>I am getting one value from a form and I need to search multiple tables
>>to
>see if this field matches.. the tricky part is I need to basically
search
>all the columns in all the tables for this value 

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

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