RE: [PHP-DB] re: Advice on searching multiple tables

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@lists.php.net 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@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net