35 lines
776 B
PHP
35 lines
776 B
PHP
<?php
|
|
include "db.php";
|
|
|
|
$school_num = 403;
|
|
|
|
$query = "SELECT p.record_num,category_num FROM people AS p, people_categories AS pc " .
|
|
"WHERE p.school_num = $school_num " .
|
|
"AND pc.school_num = $school_num " .
|
|
"AND pc.people_num = p.record_num " .
|
|
"AND pc.category_num IN (23,24,25) " .
|
|
"ORDER BY category_num";
|
|
$students = db_query($query);
|
|
|
|
while ($row = db_fetch_assoc($students)) {
|
|
extract($row);
|
|
|
|
switch ($category_num) {
|
|
case 23:
|
|
$meal_location = 7949;
|
|
break;
|
|
|
|
case 24:
|
|
$meal_location = 7945;
|
|
break;
|
|
|
|
case 25:
|
|
$meal_location = 7947;
|
|
break;
|
|
}
|
|
|
|
db_query("UPDATE people SET meal_location = $meal_location WHERE record_num = $record_num");
|
|
}
|
|
|
|
?>
|