This worked great. I am keeping a table of available PINs for each of my "groups" of students. I rewrote the code to get a random number from the table and if if it updates the student successfully, it deletes the number from the "availables" table. Thanks a lot! On Monday 11 August 2003 03:09 pm, Mike Brum wrote: > Why is it important that you "recycle" old PINs? This is most likely eating > up the most time in your script execution. > > My suggestion would be to either > > A) just keep creating a new one and ignore ones when a child leaves or > > B) create a 2nd, much smaller table "available_pins" and when a child > leaves, insert their former PIN into this table. Then upon executing the > new student script, you check the available_pin table for rows > 0. If so, > use the first one. If not, give them a new one. > > Good luck. > > -M > > -----Original Message----- > From: Michael Cortes [mailto:cortesm@fortleboeuf.net] > Sent: Monday, August 11, 2003 2:57 PM > To: Ben Lake > Cc: php-db@lists.php.net > Subject: Re: Maximum execution time of 30 seconds exceeded > > > I do have an auto_increment for the record id. But that is just a way for > me > to uniquely id the record. Student numbers, barcodes, etc can change. > > The reason I am using the do/while loop is: Every student is getting a > 4digit pin for library, cafeteria and network access. It has to be unique > and we have been assigning a different range of numbers per building/grade. > > There are various procedural reasons for this. I have verified that I am > identifying the new student correctly and going into the do/while loop with > a > variable that holds the correct starting number for the appropriate pin > range. It's then just a matter of trying consecutive numbers till I find > an > > available pin. The pin may be available because a student left the school > or > because it's next available at the end of the line. > > Anyway, I was not aware I could pick and choose my ranges in an > AUTO_INCREMENT > field. > > I appreciate any thoughts you may have. Thanks. > > On Monday 11 August 2003 02:41 pm, you wrote: > > Why don't you use an AUTO_INCREMENT field in your table to define a > > unique number? > > > > Ben > > > > -----Original Message----- > > I had a do while loop such as > > > > do { > > mysql_query ($qupdate, $link); > > $rslterror=mysql_error($link); > > $number++ > > } while ($rslterror!=null); > > > > Anyway, I fixed my dumb mistake. If anyone would like to help me with > > a better one, maybe you can tell me if I am doing my do while > > correctly. It's only running through once, not getting a succesful > > insert and dropping out. > > > > Thanks -- Michael Cortes Fort LeBoeuf School District 34 East Ninth Street PO Box 810 Waterford PA 16441-0810 814.796.4795 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
