global $keyword, $criteria, $number_of_search_results, $result, $message, $mode, $var; $mode = ""; $mode = $_REQUEST['mode']; $var = "createorder"; if (!empty($_POST['keyword'])) { // We have work... $supplier_obj = new supplier(); $supplier_obj->setsearch_keyword($_POST['keyword']); $supplier_obj->setcriteria($_POST['criteria']); $keyword = $supplier_obj->getkeyword(); $criteria = $supplier_obj->getcriteria(); $supplier_obj->dbconnect(); $supplier_obj->dbselect(); if ($keyword == "*") { //$sql2="select Suplier_id,Company_Name,Contact_Person from care_tz_supplier_deatail ORDER BY Suplier_id DESC"; $result = $supplier_obj->get_all_suppliers(); } else { if ($keyword && $criteria) { $result = $supplier_obj->get_criteria_search_results($criteria, $keyword); } } if ($result) { $number_of_search_results = $supplier_obj->recordcount($result); $message = ""; $bg_color_change = 1; //#CCCCCC#ffffaa#EEEEEE#ffffdd while ($search_element = $supplier_obj->fetch_object($result)) { if ($bg_color_change) { $http_buffer .= "<tr bgcolor=#CCCCCC>"; $bg_color_change = 0; } else {