Notice (8): Undefined index: where [APP/controllers/table_controller.php, line 43]
Code | Context
            )));
        }
        $output = call_user_func_array(array(&$controller, $params['action']), $params['pass']);
$offset	=	0
$area	=	array(
	"指定無し",
	"広島市",
	"　中区",
	"　東区",
	"　南区",
	"　西区",
	"　安佐南区",
	"　安佐北区",
	"　安芸区",
	"　佐伯区",
	"安芸郡",
	"　府中町",
	"　海田町",
	"　熊野町",
	"　坂町",
	"呉市",
	"廿日市市",
	"江田島市"
)
$service	=	array(
	"一般歯科",
	"矯正歯科",
	"小児歯科",
	"口腔外科"
)
$options	=	array(
	"駐車場",
	"車椅子対応",
	"軽度障害者",
	"重度障害者",
	"在宅訪問歯科健診",
	"施設訪問歯科健診",
	"事業所歯科健診",
	"妊婦歯科健診協力医",
	"節目年齢歯科健診協力医",
	"在宅ねたきり高齢者歯科治療協力医",
	"介護予防事業協力医"
)
TableController::index() - APP/controllers/table_controller.php, line 43
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86

Warning (2): implode() [function.implode]: Invalid arguments passed [APP/controllers/table_controller.php, line 46]
Code | Context

            //トータル数
            $sql    = "SELECT distinct members.mid FROM members NATURAL LEFT JOIN openhours WHERE ".implode(" AND ",$where).";";
$offset	=	0
$area	=	array(
	"指定無し",
	"広島市",
	"　中区",
	"　東区",
	"　南区",
	"　西区",
	"　安佐南区",
	"　安佐北区",
	"　安芸区",
	"　佐伯区",
	"安芸郡",
	"　府中町",
	"　海田町",
	"　熊野町",
	"　坂町",
	"呉市",
	"廿日市市",
	"江田島市"
)
$service	=	array(
	"一般歯科",
	"矯正歯科",
	"小児歯科",
	"口腔外科"
)
$options	=	array(
	"駐車場",
	"車椅子対応",
	"軽度障害者",
	"重度障害者",
	"在宅訪問歯科健診",
	"施設訪問歯科健診",
	"事業所歯科健診",
	"妊婦歯科健診協力医",
	"節目年齢歯科健診協力医",
	"在宅ねたきり高齢者歯科治療協力医",
	"介護予防事業協力医"
)
$where	=	null
implode - [internal], line ??
TableController::index() - APP/controllers/table_controller.php, line 46
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 685]
Code | Context

        if ($this->error) {
            $this->showQuery($sql);
$sql	=	"SELECT distinct members.mid FROM members NATURAL LEFT JOIN openhours WHERE ;"
$error	=	"1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"
$out	=	null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 685
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 267
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 411
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 288
Model::query() - CORE/cake/libs/model/model.php, line 2489
TableController::index() - APP/controllers/table_controller.php, line 47
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86

Query: SELECT distinct members.mid FROM members NATURAL LEFT JOIN openhours WHERE ; 

Warning (2): implode() [function.implode]: Invalid arguments passed [APP/controllers/table_controller.php, line 52]
Code | Context

            //ページ
            $sql    = "SELECT distinct members.mid,name_full,addr1,tel,lat,lon FROM members NATURAL LEFT JOIN openhours WHERE ".implode(" AND ",$where)." ORDER BY name_kana,mid LIMIT 21 OFFSET ".(20*$offset).";";
$offset	=	0
$area	=	array(
	"指定無し",
	"広島市",
	"　中区",
	"　東区",
	"　南区",
	"　西区",
	"　安佐南区",
	"　安佐北区",
	"　安芸区",
	"　佐伯区",
	"安芸郡",
	"　府中町",
	"　海田町",
	"　熊野町",
	"　坂町",
	"呉市",
	"廿日市市",
	"江田島市"
)
$service	=	array(
	"一般歯科",
	"矯正歯科",
	"小児歯科",
	"口腔外科"
)
$options	=	array(
	"駐車場",
	"車椅子対応",
	"軽度障害者",
	"重度障害者",
	"在宅訪問歯科健診",
	"施設訪問歯科健診",
	"事業所歯科健診",
	"妊婦歯科健診協力医",
	"節目年齢歯科健診協力医",
	"在宅ねたきり高齢者歯科治療協力医",
	"介護予防事業協力医"
)
$where	=	null
$sql	=	"SELECT distinct members.mid FROM members NATURAL LEFT JOIN openhours WHERE ;"
$total_n	=	1
implode - [internal], line ??
TableController::index() - APP/controllers/table_controller.php, line 52
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY name_kana,mid LIMIT 21 OFFSET 0' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 685]
Code | Context

        if ($this->error) {
            $this->showQuery($sql);
$sql	=	"SELECT distinct members.mid,name_full,addr1,tel,lat,lon FROM members NATURAL LEFT JOIN openhours WHERE  ORDER BY name_kana,mid LIMIT 21 OFFSET 0;"
$error	=	"1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY name_kana,mid LIMIT 21 OFFSET 0' at line 1"
$out	=	null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 685
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 267
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 411
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 288
Model::query() - CORE/cake/libs/model/model.php, line 2489
TableController::index() - APP/controllers/table_controller.php, line 54
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 86

Query: SELECT distinct members.mid,name_full,addr1,tel,lat,lon FROM members NATURAL LEFT JOIN openhours WHERE  ORDER BY name_kana,mid LIMIT 21 OFFSET 0;