X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fmanage%2Fgl_account_types.php;h=27141d53d326f8f423c64a77079cdc8276cddf93;hb=2a42ffb56ef6651b8a136cd89271e65d397d7677;hp=e6445a56c23a705494186dc7cba91e2fac382b50;hpb=8ea6c4dd0d9b31b3456d012b0c94339b801bee0c;p=fa-stable.git diff --git a/gl/manage/gl_account_types.php b/gl/manage/gl_account_types.php index e6445a56..27141d53 100644 --- a/gl/manage/gl_account_types.php +++ b/gl/manage/gl_account_types.php @@ -77,8 +77,10 @@ function can_delete($selected_id) { if ($selected_id == -1) return false; + $type = db_escape($selected_id); + $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_master - WHERE account_type=$selected_id"; + WHERE account_type=$type"; $result = db_query($sql, "could not query chart master"); $myrow = db_fetch_row($result); if ($myrow[0] > 0) @@ -88,7 +90,7 @@ function can_delete($selected_id) } $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_types - WHERE parent=$selected_id"; + WHERE parent=$type"; $result = db_query($sql, "could not query chart types"); $myrow = db_fetch_row($result); if ($myrow[0] > 0)