function get_deal_properties($d_id) { $sql = "SELECT * FROM DEALS WHERE D_ID=" . $d_id . ";"; $result = $this->mysqli->query($sql); if ($result) { $row = $result->fetch_row(); $deal['id'] = $d_id; $deal['type_id'] = $row[1]; $deal['type'] = trade::get_deal_type_by_type_id($row[1]); $deal['date'] = $row[2]; $deal['desc'] = $row[3]; $deal['status_id'] = $row[4]; $deal['status'] = trade::get_deal_status_name($row[4]); $deal['p_id'] = $row[5]; $deal['usr_id'] = $row[6]; $deal['2p_id'] = $row[7]; $deal['num'] = $row[8]; } return $deal; }