I have a site with horse racing results and the results table consists of: Date, Time, Course, Horse, Odds, Result, Profit
I have about 6 months results in there and obviously there are no unique fields. Each morning I imprt a new spreadsheet with the days racing selections without the odds and result field filled in. As the day goes on I use a page to update the results but when I update a race with horse that has run in the past it updates the new record and the old record as well. I now have 2 identical records as the data updates has overwritten the old record for the horses race before. Any ideas!?!?!?!? -- View this message in context: http://www.nabble.com/Problem-with-updating-table-tf2089249.html#a5758339 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
