RE: [PHP-DB] search question

2002-09-17 Thread Cal Evans
it depends on how you design your database. When I know I will have this situation, I design a table named keyWords. Put one work per record and assign each word an ID number. Then I create a join table between keyWords and whatever table they relate to. The join table only contains 2 fields,

RE: [PHP-DB] search question

2002-09-17 Thread John Holmes
PROTECTED] Subject: RE: [PHP-DB] search question it depends on how you design your database. When I know I will have this situation, I design a table named keyWords. Put one work per record and assign each word an ID number. Then I create a join table between keyWords and whatever table