function getListofMembershipInfo($pageNO, $schStr, $mode, $sortField = 0, $sortOrder = 'ASC') { $tableName = 'HS_HR_MEMBERSHIP'; $tableName2 = 'HS_HR_MEMBERSHIP_TYPE'; $arrFieldList[0] = 'MEMBSHIP_CODE'; $arrFieldList[1] = 'MEMBSHIP_NAME'; $arrFieldList2[0] = 'MEMBTYPE_NAME'; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->table2_name = $tableName2; $sql_builder->flg_select = 'true'; $sql_builder->arr_select = $arrFieldList; $sql_builder->arr_select2 = $arrFieldList2; $sql_builder->field = 'MEMBTYPE_CODE'; $sqlQString = $sql_builder->passResultSetMessageMulti($pageNO, $schStr, $mode, $sortField, $sortOrder); //echo $sqlQString; $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function $i = 0; while ($line = mysql_fetch_array($message2, MYSQL_NUM)) { $arrayDispList[$i][0] = $line[0]; $arrayDispList[$i][1] = $line[1]; $arrayDispList[$i][2] = $line[2]; $i++; } if (isset($arrayDispList)) { return $arrayDispList; } else { $arrayDispList = ''; return $arrayDispList; } }