In which case you need to set a variable before including "common" and then get common to act on it. I would recommend a start parameter and limit (much like SQL).
Newsflash, the number in the brackets isn't used it's only for display-width, INT(1) and INT(10) are the same, it's the type of int that counts, e.g. SMALLINT, TINYINT or INT.
//updates the db table sets all passed events to archive = 1
UPDATE table SET archive = 1 WHERE event_date < NOW()
//selects all non passed (archived) events from db table
SELECT xxxx FROM table...
your last paragraph should be in red/pink and huge lettering, i like it sums up this thread completly, good job and welcome to the forums i know ou have 823 posts but ive never seen you before :)
yes it was sarcastic, i am sorry i take that back this thread is only 1 month old, i thought it was much older thats why i sighed to see yet another new user drag up and old thread, which sends...