[PHP] keyword search help

2002-02-07 Thread Arun K . V
hello sir, we are creating a cdrom database in postgresql wherein we have cd rom titlename,author,year etc and keywords as fields. we will store a set of keywords for each record. i want to know how to enter those keywords in to database (whether to have comma between keywords or

Re: [PHP] keyword search help

2002-02-07 Thread Jeff Sheltren
Not really a php question, is it? But what I would do is have two tables, a cdrom table and a keyword table. Each cd in the cd table would have a cd_id, and then the keyword table could have two attributes, cd_id (foriegn key from cdrom table) and keyword. Make the primary key for the