addDataParam('i', $owner_id); if (!$no_url) { $sql .= ' LIMIT ?, ?'; $data_params->addDataParam('i', (($page - 1) * $pageRecord)); $data_params->addDataParam('i', $pageRecord); } $rs = $wrapperObj->executeQuery($sql, $data_params); if ($rs === false) { showierror($sql); } $sql = 'SELECT FOUND_ROWS() AS total'; $data_params = new QueryData(); $total_count = $wrapperObj->executeQuery($sql, $data_params); if ($total_count === false) { showierror($sql); } $total_count_row = $total_count[0]; $total = $total_count_row['total']; $pageNum = ceil($total/$pageRecord); } ?> if ($total) { echo paginate($page, $pageRecord, $pageNum, $varQueryString); } ?>
| =sortColumnHeader('Label Name', 'company', $url)?> | =sortColumnHeader('Artist Name', 'artist_name', $url)?> | =sortColumnHeader('UPC', 'upc', $url)?> | =sortColumnHeader('Release Name', 'release_name', $url)?> | =sortColumnHeader('Label Rep.', 'assigned_to', $url)?> | =sortColumnHeader('Genre', 'genre', $url)?> | =sortColumnHeader('Release Date', 'release_date', $url)?> | |||
|---|---|---|---|---|---|---|---|---|---|
| =$row['company']?> | =$row['artist_name']?> | =$row['display_upc']?> | =$row['release_name']?> | =$row['assigned_to']?> | =$row['genre']?> | =$row['release_date']?> | |||
| No Labels found. | |||||||||