var_dump(PDO::getAvailableDrivers());

mysql_connect('localhost', '', '');
        mysql_select_db('world');
        
        $query = sprintf('SELECT country.Continent, country.Name, GROUP_CONCAT(city.Name) AS Cities
                            FROM country 
                            LEFT JOIN city ON city.CountryCode = country.Code                        
                            WHERE ((country.Continent LIKE "%s")
                            AND (country.Name LIKE "%s"))
                            GROUP BY country.Code
                            ORDER BY Continent, Name;',
                (isset($_GET['continent']) ? $_GET['continent'] : '') . '%',
                (isset($_GET['country']) ? $_GET['country'] : '') . '%'
        );
                      
        $result = mysql_query($query);
        
        $world = array();
        while ($row = mysql_fetch_assoc($result)) {
            $row['Cities'] = isset($row['Cities']) ? explode(',', $row['Cities']) : array();
            $world[] = $row;
        }        
        mysql_close();
        
        var_dump($world);

-- --------------------------------------------------------
-- Хост:                         localhost
-- Версия сервера:               5.6.10 - MySQL Community Server (GPL)
-- ОС Сервера:                   Win32
-- HeidiSQL Версия:              7.0.0.4387
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Дамп структуры базы данных jsalon
CREATE DATABASE IF NOT EXISTS `jsalon` /*!40100 DEFAULT CHARACTER SET cp1251 */;
USE `jsalon`;


-- Дамп структуры для процедура jsalon.find_by_mark_model_year
DELIMITER //
CREATE DEFINER=`root`@`127.0.0.1` PROCEDURE `find_by_mark_model_year`(IN `mark` VARCHAR(100), IN `model` VARCHAR(100), IN `year` VARCHAR(100))
    READS SQL DATA
BEGIN
	SET mark = CONCAT(IFNULL(mark, ''), '%');
	SET model = CONCAT(IFNULL(model, ''), '%');
	SET year = CONCAT(IFNULL(year, ''), '%');
	
	SELECT a.*, b.big, b.small
	FROM add_new_car AS a 
	LEFT OUTER JOIN (
		SELECT user_id, MIN(big) AS big, small 
		FROM image_add_car
		GROUP BY user_id
	) AS b ON a.id_add_car = b.user_id 
	WHERE a.mark LIKE mark AND a.model LIKE model AND a.year LIKE year 
	ORDER BY a.id_add_car;	
END//
DELIMITER ;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

        $mark   =& $_GET['mark'];
        $model  =& $_GET['model'];
        $year   =& $_GET['year'];
        
        mysql_connect('localhost', '', '');
        mysql_select_db('jsalon');
        
        $query = sprintf('call find_by_mark_model_year("%s", "%s", "%s");',
                $mark,
                $model,
                $year
        );
               
        $result = mysql_query($query);
        while($rows = mysql_fetch_array($result, MYSQL_ASSOC)) {
            var_dump($rows);        
        }
        mysql_close();