X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Finquiry%2Fwhere_used_inquiry.php;h=c10dc2a7aa039af1ce06f44a5c493a7f69dcfe7e;hb=36ec54507b7841b2352734b81e45b95e371ecdab;hp=aeea81cfff528df9cea28ecec19628bf45936522;hpb=902f1015d874c33bd7946b17de2ad80b4f2144b6;p=fa-stable.git diff --git a/manufacturing/inquiry/where_used_inquiry.php b/manufacturing/inquiry/where_used_inquiry.php index aeea81cf..c10dc2a7 100644 --- a/manufacturing/inquiry/where_used_inquiry.php +++ b/manufacturing/inquiry/where_used_inquiry.php @@ -50,7 +50,7 @@ $sql = "SELECT WHERE bom.parent = parent.stock_id AND bom.workcentre_added = workcentre.id AND bom.loc_code = location.loc_code - AND bom.component='" . $_POST['stock_id'] . "'"; + AND bom.component=".db_escape($_POST['stock_id']); $cols = array( _("Parent Item") => array('fun'=>'select_link'), @@ -61,9 +61,6 @@ $sql = "SELECT $table =& new_db_pager('usage_table', $sql, $cols); -if (get_post('_stock_id_update')) - $table->set_sql($sql); - $table->width = "80%"; display_db_pager($table);