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

Reply via email to