Help with JOIN

4 posts by 3 authors in: Forums > CMS Builder
Last Post: March 24, 2009   (RSS)

By (Deleted User) - March 24, 2009

Hello,

I have a quick question, I'm using CMS Builder for a directory. I would like users of the directory to be able to list item that they sell. I do not know how to join the 2 tables so when someone clicks on "store1" only store1's items for sale display.

I am trying to do this in an iframe (is this the best way to do this?)

I hope I'm making sense in what I'm looking to do?

Thanks,
James

Re: [ross] Help with JOIN

By (Deleted User) - March 24, 2009

Hi Ross,

That is exactly correct.

Thanks for the quick reply,
James

Re: [DiscoverSC] Help with JOIN

By Dave - March 24, 2009

Hi James,

The simplest way would be to use the built in search features described here:
http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html

You can pass the record "num" of the store in the link to filter the results. So say you had a page called products.php that listed all your products. And your products section had a field called "storeNum" which loaded values from the Store section (using num as the value, and name as the label). You could show only the results from a specific store like this:

products.php?storeNum=2

Hope that helps! Let me know if that makes sense.
Dave Edis - Senior Developer
interactivetools.com