Patrick Wirz wrote:
> 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.
create table keywords ( id mediumint not null primary key, word
create table img_keyword( img_id int not null, keyword_id mediumint not