X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fmanage%2Fitem_categories.php;h=149e23e65746acef08af873d36665e94d000f869;hb=54d84ff9a67620ab38c676cdbcf87853632724f0;hp=4bf0cd78036304d2edbb0ae06dc9dea8c2b9d036;hpb=c09be0dad6b05131e240349a375af7a4b7bf3444;p=fa-stable.git diff --git a/inventory/manage/item_categories.php b/inventory/manage/item_categories.php index 4bf0cd78..149e23e6 100644 --- a/inventory/manage/item_categories.php +++ b/inventory/manage/item_categories.php @@ -1,5 +1,14 @@ . +***********************************************************************/ $page_security = 11; $path_to_root="../.."; include($path_to_root . "/includes/session.inc"); @@ -48,7 +57,7 @@ if ($Mode == 'Delete') { // PREVENT DELETES IF DEPENDENT RECORDS IN 'stock_master' - $sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE category_id='$selected_id'"; + $sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE category_id=".db_escape($selected_id); $result = db_query($sql, "could not query stock master"); $myrow = db_fetch_row($result); if ($myrow[0] > 0) @@ -86,7 +95,7 @@ while ($myrow = db_fetch($result)) label_cell($myrow["description"]); edit_button_cell("Edit".$myrow[0], _("Edit")); - edit_button_cell("Delete".$myrow[0], _("Delete")); + delete_button_cell("Delete".$myrow[0], _("Delete")); end_row(); } @@ -97,7 +106,7 @@ echo '
'; start_form(); -start_table("class='tablestyle_noborder'"); +start_table($table_style2); if ($selected_id != -1) {