I'm trying to figure out the best way to do this. People will be signing up online and their info will be put into a database. They will be assigned a room and each successive person will be assigned a different room. There are different categories for each group of people also. So there will be: Group1 -Rm101 -Rm102 -Rm103 Group2 -Rm300 -Rm301 etc. They need to have an equal amount of people in each room so the first person in Group1 would Rm101, next person Rm102 etc. Would it be best to retrieve the last person from the Group, find out what room number they have, then if last in Group1 is Rm101, this person be assigned Rm102 with that equation being in the PHP script? If that's the case would I retrieve all the records for Group1 and find the largest ID (auto_increment type)? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
