in reply to How to check for new records in mysql database every minute

What's to figure out?

# Make a connection to the database; # While not killed by a signal # Check to see if there are any new records, and do # something with the new records; # Sleep for some period; # Close the connection to the database.

Alex / talexb / Toronto

"Groklaw is the open-source mentality applied to legal research" ~ Linus Torvalds

Update: Well, my comments were intended for some definition of new. I was leaving the details of the solution to the Original Poster, as the problem definition was itself somewhat vague. If that wasn't useful, I'll try to reply to open-ended nodes like this one less often.

Replies are listed 'Best First'.
Re^2: How to check for new records in mysql database every minute
by ikegami (Patriarch) on Oct 05, 2004 at 21:40 UTC
    "Check to see if there are any new records" ain't easy!! Can't just count them, cause it must support DELETEs.