Administrator / extremepride

<?php
class Model_Get_Brends_Json extends Model
{



	
    public function get_shops($city,$rayon,$brend_id)
    {	
	//$lang = $this->lang_on();
	//$pdo = $this->controller->pdo_connect();
	//$new_orders = self::$pdo->query("select count(*) from users")->fetchColumn();
	
							$sql = 'SELECT s.* FROM shops s,catalogs_brends_keys k  WHERE s.city="'.$city.'" AND s.rayon="'.$rayon.'" AND k.shop_id=s.id AND k.brend_id="'.$brend_id.'"';
                            $query = self::$pdo->prepare($sql);
                            $query->execute();
                            
							$arr = array();
							$num = 0;
	                        while ($row = $query->fetchObject()) {								
								$arr[$num][id] = $num;
								$arr[$num][city] = $row->city;
								$arr[$num][rayon] = $row->rayon;
								$arr[$num][adress] = $row->adress;
								$arr[$num][name] = $row->name;
								$arr[$num][contacts] = $row->contacts;
								$arr[$num][url] = $row->url;
								$arr[$num][pic] = '/pics/shops/'.$row->pic;
								$num++;
							}
        return $arr;
    }	
}