MySQL Lists are EOL. Please join:

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
create table img_keyword( img_id int not null, keyword_id mediumint not
Sasha Pachev (home) (work)
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