I think this is more of a Programming problem, but to get you started. In your database add a field call it updated make it char(1) like ALTER TABLE Hockey ADD Updated char(1) default NULL;
On the first page when you start processing the players put in a programming line to update all the players like.. UPDATE Hockey SET Updated = 'N'; Then in your update page do SELECT * FROM Hockey WHERE Updated = 'N'; If there are any records in the set continue processing else go to finished page. When you update that particular players stats don't forget to SET Updated = 'Y'; Hope this helps. Roger -----Original Message----- From: C. Reeve [mailto:[EMAIL PROTECTED] Sent: Saturday, March 08, 2003 6:44 PM To: MySQL List Subject: Part Mysql part PHP question.... Hi, I have a hockey database with players names in it and I want to be able to update their stats one after the other. To be more clear - when the page is first entered I want the first players name to automatically appear showing his current stats (this will be in a form). Then you can update the record and write it back to the database, then the next player will show up with his stats showing, and the process continues until all the players have been done. Setting up the database and forms is no problem, but I'm not sure how I would keep count of what player has been done so the next one automatically appears (and if there should be a power failure orWindows crashes, or whatever else - I want the process to start at the last player being updated - I don't want to have to start again from player one). I'm not sure if this is more a PHP or MySQL question - or both - so I have sent it to both lists. Thanks C. Reeve --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
