List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 6 1999 9:35pm
Subject:Re: keyword search data structure
View as plain text  
Patrick Wirz wrote:
> 
> Hi,
> 
> What would be the best (i.e. fastest, most efficient) way to assign about 5
> keywords to items in a catalog in order to search? Here's the scenario:
> 
> I've got a database of images. I'd like to assign around 5 words describing
> what's in each image to enable searching. The database of images is used to
> create catalog pages (via PHP) so speed is very important.
> 
> I seem to remember a discussion similar to this a few months ago but
> couldn't find it in the archives.
> 
> Thanks,
> -Pat
> 

create table keywords ( id mediumint not null primary key, word
char(15));
create table img_keyword( img_id int not null, keyword_id mediumint not
null);
  
-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
Re: Text Field Sizes and PHP (was: Access -> myODBC or -> textfile?)jawarren23 Jun
  • Re: Text Field Sizes and PHP (was: Access -> myODBC or ->textfile?)Mike Hanney23 Jun
    • keyword search data structurePatrick Wirz6 Jul
    • Re: keyword search data structureSasha Pachev7 Jul
    • Re: keyword search data structurePatrick Wirz7 Jul
    • Re: keyword search data structureSasha Pachev8 Jul