20 lines
633 B
PHP
20 lines
633 B
PHP
<?php
|
|
include "db.php";
|
|
|
|
$school_num = 491;
|
|
|
|
$items = db_query("SELECT hlmi.record_num " .
|
|
"FROM `hotlunch_menu_items` AS hlmi, hotlunch_menu_dates AS hlmd " .
|
|
"WHERE hlmi.school_num = $school_num " .
|
|
"AND hlmd.school_num = $school_num " .
|
|
"AND hlmd.schedule_num = 5239 " .
|
|
"AND hlmd.record_num = hlmi.menu_num " .
|
|
"AND item_title NOT LIKE '%milk%'");
|
|
|
|
while ($row = db_fetch_assoc($items)) {
|
|
extract($row);
|
|
db_query("DELETE FROM hotlunch_menu_items WHERE school_num = $school_num AND record_num = $record_num");
|
|
}
|
|
|
|
?>
|