21 lines
523 B
PHP
21 lines
523 B
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$users = db_query("SELECT * FROM users WHERE can_order = 'Balance' ORDER BY school_num");
|
|
|
|
$prev_school = 0;
|
|
while ($row = db_fetch_assoc($users)) {
|
|
extract($row);
|
|
|
|
if ($school_num != $prev_school) {
|
|
$results = db_query("SELECT * FROM schools WHERE record_num = $school_num");
|
|
$school_record = db_fetch_assoc($results);
|
|
}
|
|
|
|
if ($school_record['allow_ordering_with_balance_owing'] == 'Y') db_query("UPDATE users SET can_order = 'Yes' WHERE record_num = $record_num");
|
|
|
|
}
|
|
|
|
?>
|