/* Template Name: front-tunings */get_header(); global $wpdb, $prod_id, $action,$woocommerce; $brands = $wpdb->get_row("SELECT * FROM `tbl_brands` where id= '".ch('bid')."' ", OBJECT); $models = $wpdb->get_row("SELECT * FROM `tbl_models` where id= '".ch('model')."' ", OBJECT); $gt_da_r=$wpdb->get_row("SELECT * FROM `tbl_building_year` WHERE `id` = '".ch('bulding_year')."'"); $gt_engin_type=$wpdb->get_row("SELECT * FROM `engin_type` WHERE `id` = '".ch('engin_type')."' "); ?> $sql="SELECT * FROM `tbl_tunings` where model_id = '".$gt_engin_type->model_id."' AND year_build_id = '".$gt_da_r->id."' AND engin_type = '".$gt_engin_type->id."' "; $data = $wpdb->get_results($sql, OBJECT ); ?>