function cxkindex(){ $db_user = spClass('cali_user'); $this->getmodel = json_encode($db_user->findsql("SELECT cali_brand.`code`, cali_brand.brandname, cali_series.seriesname, cali_model.id, cali_model.modelname, cali_model.country, cali_model.`year`, cali_model.displacement, cali_model.power FROM cali_brand INNER JOIN cali_model ON cali_brand.id = cali_model.brandid INNER JOIN cali_series ON cali_series.id = cali_model.seriesid ORDER BY cali_brand.`code` ASC")); //print_r($this->getmodel); $this->display('cxkindex.html'); }