/* Template Name: brands */get_header();
global $wpdb, $prod_id, $action,$woocommerce;
if (!is_user_logged_in() ){
echo "Restricted Content!";
die();
}
?>
ID |
Brand |
Description |
Image |
Action |
$sql_nf;
$sql="SELECT * FROM `tbl_brands` where id <> '' ";
$cur_page = intval(ch_page('cur'));
$prod_page = 150;
$perpage = $prod_page;
if ($cur_page == 1)
{
$subt = 0;
}else{
$subt = $cur_page * $prod_page;
$subt = $subt - $prod_page;
}
$rows = $wpdb->get_results(" SELECT COUNT(*) as num_rows FROM tbl_brands where rel_id <> '' ".$sql_nf." ");
$rs_n=$rows[0]->num_rows;
$sql.= $order_by;
$sql;
$sql.= " Limit $subt,$perpage";
if (ch('cur')=='') {
$page_number=1;
$rstart=0;
$rend=$prod_page;
}else{
$page_number=ch('cur');
$rstart=($subt+$prod_page)-$prod_page;
$rend=$subt+$prod_page;
}
$sql;
$data = $wpdb->get_results($sql, OBJECT );
?>
|
|
|
|
|
}?>