To answer and clarify some things:

I am saving my sessionid's on File at the moment. Thanks for good input on database calls.

However, I think you missunderstood what I meant with a shopping cart

A shopping cart is a TEMPORARY storage place where my customers put information on objects they are planning to buy.
When they are done shopping they will checkout their objects, they will receive an orderreceipt.
Relations between customer and shopping cart will be deleted.
They also have a choise of not going to the checkout, in that case relations between customer and shopping cart will be deleted.

So what information am I intrested in at the moment or will be in the future.

I already have information on my products, I store that in my PRODUCTS table
I want information on my customer, I store that in my CUSTOMER table when the customer checkout
I want information on what my customer bought, I store that in my ORDER table

Do I really want information on what products my customers put in their temporary shopping carts, products that at the end, won't be bought?


In reply to Re^3: Code Design Issues by boboson
in thread Code Design Issues by boboson

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.