addDataParam('i', $dra_optout_id); if(!$no_url) { $sql .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $rs = $wrapperObj->executeQuery($sql, $dataParams); if ($rs === false) { showierror($sql); } $sql = 'SELECT FOUND_ROWS() AS total'; $dataParams = new QueryData(); $total_count = $wrapperObj->executeQuery($sql, $dataParams); if ($total_count === false) { showierror($sql); } $total_count_row = $total_count[0]; $total = $total_count_row['total']; $pageNum = ceil($total/$pageRecord); $varTable .=' '.($no_url ? "Label ID" : sortColumnHeader('Label ID', 'vendor_id', $url)).' '.($no_url ? "Label" : sortColumnHeader('Label', 'company', $url)).' '.($no_url ? "Opt-In / Opt-Out" : sortColumnHeader('Opt-In / Opt-Out', 'optin_or_out', $url)).' '; if (count($rs)) { $rci = 0; foreach ($rs as $row) { $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .= ' '.$row['vendor_id'].' '.$row['company'].' '.ucwords($row['optin_or_out']).' '; } } else { $varTable .= ' No Response Found. '; } $varTable .= ''; ?>