I have a db table that receives weather data several times a day via a php script and cron job. Sometimes the data is duplicated for a certain time window.
11:50 44 degree 11:50 44 degree 11:40 45 degree 11:30 46 degree 11:20 46 degree 11:10 45 degree I do not want the duplicate data for the 11:50 time slot to be inserted into my table. Is there a common method used to check if data already exists in a db table and if so to cancel the data insertion? What is this called? Is this demonstrated in the MySQL book or documentation. If I knew what this was called, I might have better luck finding solution. Thanks Craig ><> [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
