Currently Searching by: "; $q = " SELECT `amazon-order-id` , `purchase-date` , `last-updated-date` , `order-status` , `fulfillment-channel` , `sales-channel` , `order-channel` , `sku` , `item-status` , `quantity` , `date` FROM `amz_orders_4weeks` "; if ($form_key) { $q .= " WHERE 1=1 "; } if (!empty($order_status)) { $q .= " AND `order-status` LIKE '%".$order_status."%'"; echo " Order Status = '" .$order_status. "', ";} if (!empty($fulfillment_channel)) { $q .= " AND `fulfillment-channel` LIKE '%".$fulfillment_channel."%'"; echo " fullfillment channel = '" .$fulfillment_channel. "', ";} if (!empty($sku_search)) { $q .= " AND `sku` LIKE '%".$sku_search."%'"; echo "Sku = '" .$sku_search. "', ";} if (!empty($Item_Status)) { $q .= " AND `item-status` = '".$Item_Status."'"; echo " Item Status = '" .$Item_Status. "', ";} if (!empty($Sales_Channel)) { $q .= " AND `sales-channel` = '".$Sales_Channel."'"; echo " Sales Channel = '" .$Sales_Channel. "', ";} if (!empty($quantity_search)) { $q .= " AND `quantity` = '".$quantity_search."'"; echo " Quantity = '" .$quantity_search. "', ";} if (!empty($purchase_date)) { $q .= " AND `purchase-date` LIKE '".$purchase_date."%'"; echo " Puchase date = '" .$purchase_date. "', ";} if (!empty($updated_date)) { $q .= " AND `last-updated-date` LIKE '".$updated_date."%'"; echo " Last updated date = '" .$updated_date. "', ";} if (!empty($date_range)) { $q .= " AND `date` ".$date_range; echo " Date Range = '" .$date_range. "', ";} }/*End if (!empty($form_key))*/ echo ""; echo '

DEBUGGING: Query from search_results.phtml is : ' . $q . '

'; ?>