34 lines
596 B
PHP
34 lines
596 B
PHP
<?php
|
|
|
|
include "db.php";
|
|
include "table.php";
|
|
|
|
$people = new Table("people");
|
|
|
|
$school_num = 225;
|
|
|
|
$people_type = 'Staff';
|
|
$staff_category = 3561;
|
|
$class_num = 0;
|
|
$status = 'Verified';
|
|
$display = 'Y';
|
|
$menu_price_category = 'Regular';
|
|
$added_date = date("Y-m-d",time());
|
|
|
|
|
|
$query = "SELECT * FROM users WHERE school_num = $school_num AND type = 'Staff'";
|
|
$staff = db_query($query);
|
|
|
|
while ($row = db_fetch_assoc($staff)) {
|
|
|
|
$user_num = $row['record_num'];
|
|
$first_name = $row['first_name'];
|
|
$last_name = $row['last_name'];
|
|
|
|
$query = $people->BuildInsert();
|
|
db_query($query);
|
|
|
|
}
|
|
|
|
?>
|