"complete"
AND ss.date >= (select max(date) from sony_status where upc = ss.upc and provider = "ci")
GROUP BY ss.upc';
$getq .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : '');
if($viewall){
$getq .= ' LIMIT ?, ?';
$dataParams->addDataParam('i', (($page - 1) * $pageRecord));
$dataParams->addDataParam('i', $pageRecord);
}else{
$getq .= " limit 0,5";
}
$getrs = $wrapperObj->executeQuery($getq, $dataParams);
if ($getrs === false) {
showierror($getq);
}
$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);
?>
|
|
|
|
Description |
|
|
|
|
",$row['description'])?> |