Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › SecurityAssist › Is this possible....

Is this possible....

Thread began 8/25/2010 6:02 am by iainmacdonald331081 | Last modified 8/27/2010 10:48 am by iainmacdonald331081 | 1355 views | 5 replies

8/26/2010 6:21 amiainmacdonald331081

Hi Jason - what I've done in the past is have a structure like this :

table_Products

ProductID
Product
ProductField1
ProductField2
etc

table_Buyers

BuyerID
Buyer
BuyerField1
BuyerField2
etc

tableKeywords

KeywordID
Keyword

tableProductKeywords

ProductID
KeywordID

tableBuyerKeywords
BuyerID
KeywordID

So, for example, when a new Product or Buyer is added, there is also a page listing a load of checkboxes with various Keywords, and the user just checks the ones they want to attach to the Product or Buyer.

This adds records to the ProductKeywords or BuyerKeywords table.

These can then be used to match Products with Buyers where there is a match in those tables.

So the idea here is that Buyers can register and have a profile etc, and when logged in be able to view the Products where there is a match.

Does that make sense?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.