0) { flash("Cannot delete — $cnt businesses use this category.",'error'); }
else { qrun("DELETE FROM categories WHERE id=?",[$id]); flash('Category deleted.','success'); }
}
go('/admin/categories.php');
}
$editId = iget('edit');
$editing = $editId ? qone("SELECT * FROM categories WHERE id=?",[$editId]) : null;
$cats = qall("SELECT c.*,(SELECT COUNT(*) FROM businesses WHERE category_id=c.id) biz_count FROM categories c ORDER BY c.sort_order,c.name");
?>
ALL CATEGORIES ()
| ICON | NAME | BUSINESSES | SORT | ACTIONS |
|---|
|
|
|
|
|