/* Template Name: tunings */get_header();
global $wpdb, $prod_id, $action,$woocommerce;
if (!is_user_logged_in() ){
echo "Restricted Content!";
die();
}
$gt_da="SELECT * FROM `engin_type` WHERE `id` = '".ch('engin_type')."' ";
$gt_da_r=$wpdb->get_row($gt_da);
?>
Tuning Data
Data toevoegen
ID |
Name | Href |
Action |
$sql_nf;
echo $sql="SELECT * FROM `tbl_tunings` where model_id = '".$gt_da_r->model_id."' AND year_build_id = '".$gt_da_r->buliding_year."' AND engin_type = '".$gt_da_r->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 engin_type where model_id = '".$gt_da_r->model_id."' ");
$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 );
?>
|
|
|
}?>