Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

[PHP-DB] Alternating Values From: Jeff Oien (jeff <email protected>)
Date: 07/09/01

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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>