With this scheme, you'll put all the keywords you'll use for all the pages in the keywords table, the separator you want for each page in the keyword_separator column of the main table, and the mapping of keywords to pages in the third table. An example... say you have:--------------------------------------------- | meta_table_page_info | --------------------------------------------- | page_id | page | keyword_separator | desc | --------------------------------------------- -------------------------- | keywords | -------------------------- | keyword_id | keyword | -------------------------- --------------------------- | page_to_keyword_mapping | --------------------------- | page_id | keyword_id | ---------------------------
and you want page 1 to have keywords "keyword_1,keyword_3". Then the mapping table would look like:-------------------------------------------------------------- | meta_table_page_info | -------------------------------------------------------------- | page_id | page | keyword_separator | desc | -------------------------------------------------------------- | 1 | some_page | , | some_description | -------------------------------------------------------------- -------------------------- | keywords | -------------------------- | keyword_id | keyword | -------------------------- | 1 | keyword_1 | | 2 | keyword_2 | | 3 | keyword_3 | --------------------------
To build the actual string, you'd use a SQL statement in the vein of--------------------------- | page_to_keyword_mapping | --------------------------- | page_id | keyword_id | --------------------------- | 1 | 1 | | 1 | 3 | ---------------------------
Then you execute(page_number), and go from here. This may be far more complicated than you were wanting, but designing it like this leaves lots of room for expansion.SELECT m.keyword_separator, k.keyword FROM keywords k, page_to_keyword_mapping p, meta_table_page_info m WHERE p.page_id = ? AND m.page_id = p.page_id AND k.keyword_id = p.k +eyword_id
In reply to Re: Seeking YOUR Wisdom... CGI.pm, Database and YOU
by jgallagher
in thread Seeking YOUR Wisdom... CGI.pm, Database and YOU
by powerhouse
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |