RE: [PHP] Control Structure Problem

I forgot to say I deleted tabs so that the width might fit in a typical mail reader. Jeff Oien > This code assigns rooms to kids signing up for Sunday school > at a very large church. Each subsequent registration is put into > the next room on the list. It looks up in the MySQL database > the room the last person in that age category and hour was > assigned and assigns the current person the next one. If someone > is the first person they get assigned the first room. However if > they are the first person ${"newroom".$x} doesn't get assigned > to anything. But thereafter it works fine. I've had a couple other > problems and am wondering if there is a better way to do this > or if I have any syntax problems. Thanks. > Jeff Oien > > $x = 1; > while ($x <= $Number_Children) { > > if (${"category".$x} == 'SS KidZone - Kindergarten') { > > if ((${"Grade".$x}) == 'K' && (${"selection".$x}) == > '2nd Hour') { > $sql = "SELECT * FROM $table_name WHERE Category = 'SS KidZone - Kindergarten' > && Element1 = '2nd Hour' ORDER by ID desc"; > $result = @mysql_query($sql,$connection) or die("Couldn't execute query"); > > if ($row = mysql_fetch_array($result)) { > $room = $row['Element2']; > > if ($room == 'C143 Pink Check') { > ${"newroom".$x} = 'C143 Pink Dot'; > } > if ($room == 'C143 Pink Dot') { > ${"newroom".$x} = 'C148 Teal Check'; > } > if ($room == 'C148 Teal Check') { > ${"newroom".$x} = 'C148 Teal Dot'; > } > if ($room == 'C148 Teal Dot') { > ${"newroom".$x} = 'C143 Pink Check'; > } > } > else { ${"newroom".$x} = 'C143 Pink Check'; } > } > > "do database insertion" > > } > $x++; > } > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >