15 lines
346 B
PHP
15 lines
346 B
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$query = "SELECT user_num, count(*) AS num FROM people WHERE people_type = 'Student' GROUP BY 1";
|
|
$results = db_query($query);
|
|
while ($row = db_fetch_assoc($results)) {
|
|
extract($row);
|
|
$num = intval($num);
|
|
$query = "UPDATE users SET linked_to_num = $num WHERE record_num = $user_num";
|
|
db_query($query);
|
|
}
|
|
|
|
?>
|