Post reply

How did you do the Virtual Briefcase?

  • April 3, 2007 at 1:51 pm

    #171960

    I'd like to have something similar in my web site, but a bit simpler: only one category of content and max 25 items.

    Is there a limit for number of articles, scripts, etc? And, how did you do the briefcase?

  • April 5, 2007 at 2:17 pm

    #698921

    Sorry for missing this the other day.

    We did it by creating two tables. One for things you add from the site and one for things we add, like purchased products. Probably could have done one table, but the 2nd one has download location/URL, order #, etc.

    When you click on a link, we drop the type (article, script, etc) in a table along with the PK and your member PK. Then for the listing we pull everything back based on your PK by type. So type "A" for articles joined to Articles table, Type "S" for script, joined to script table, etc.

    We also query that table to find popular items.

    Also, no limit.

  • April 5, 2007 at 11:48 pm

    #698979

    Thanks for the tip. Enlightening.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply