Hi,
I would like to assign KEYWORD to my products.
Whats the good way for it.
1)Create trans. table and assign each keyword to each products?
2) Assign all keyword with separation of comma
like : key1,key2,key3

Note: i want a search related to keyword.

please gguid me.. i am waiting for your reply.

Thanks
~Storage

What is the DB you are using? How is you search operation going to work? Can you explain on that?

_________________________
- Vijay G
Strive for Perfection

Thanks...

I am going to use MSSQL 2000 and when enduser going to search with plain word ... we have to search given keyword with alocated products.

and display distict product list.

thanks for interest...
Hopping for proper help

~Storage

When you go for the 2nd solution mentioned in your first post, you got to use that with like operator, which is a little slow. If data is not going to be huge, then you can opt for that.

But the 1st option should be a viable solution in case of huge data, where you got to use join to get the product. But the one who provides keyword should be aware of what keywords exist in the db, any mistake or half spelt would result in any product.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection