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: [DiscoverSC] Help with JOIN

By ross - March 24, 2009

Hi James

Thanks for the email!

I think I understand what you are looking for but let me know sure before we start going over code :).

Your site lists a bunch of products that are listed by different users. You want to be able to have a list that shows only one person's items. So you could have a link that says "Click here to see everything Bob is selling".

Does that sound about right? Let me know what you think and we'll go from there. Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Re: [ross] Help with JOIN

By (Deleted User) - March 24, 2009

Hi Ross,

That is exactly correct.

Thanks for the quick reply,
James