Question

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array (

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => select ap.ad_width,ap.ad_height,ad.ad_name,ad.ad_code,ad.ad_link from `ectouch`.`ecs_ad_position` as ap left join `ectouch`.`ecs_ad` as ad on ad.position_id = ap.position_id where ad.ad_name in() and ad.media_type=0 and UNIX_TIMESTAMP()>ad.start_time and UNIX_TIMESTAMP() Array ( [error] => 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 ') and ad.media_type=0 and UNIX_TIMESTAMP()>ad.start_time and UNIX_TIMESTAMP() Array ( [errno] => 1064 ) )ecshop 前台出来的，后台正常显示，有哪位大神帮帮忙啊

Answer 1

　　where ad.ad_name in('这里有没有值传进来')

PHP没接触，不过单纯看sql报错提示是说这个in这个地方有问题，是不是参数值没传进来，如果没值的话会报错的