I am building a complex system. it's actually ONE script(index.cgi) that handles everything with the help of one Custom made module that handles the MySQL connection, errors and such.

Each page that is called is a configuration file, stored in a directory not accessible via the web.

Those files use the global database connection called in the custom module.

I store tons of different tables in the one database. Each serves it's own purpose.

Now I've added a custom made affiliate program to it. The reason I built my own, is because I don't want to take someone elses and re-write it into my system.

The problem I'm faced with, is this...

If I store the "banner" or "ad" impressions in the MySQL db, and say it's 25 in the impressions record, is there a MySQL command that will just ADD ONE to the current value? Or do I have to call it in one field, store the variable until the next line, and then increment it, then write it back?

If so, what if in the unlikely chance two people access it at the same EXACT same time? would it count both as only one?

ie They both get 25 and add one, then write back to it 26.

Is there an easier way?

thx,
Richard

In reply to MySQL "Counter"? by powerhouse

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.