(错误号: 1064 Erreur de syntaxe pr(s de '5天))

Question

$this->db->select('`tbl_packing_list`.*,((SELECT SUM(`packing_list_quantity`) 
 FROM `tbl_event_packing_list` 
 WHERE `event_packing_item` = '.$data['id'].') - ( '
     .'SELECT IFNULL(SUM(`tbl_event_packing_list`.`packing_list_quantity`),0 ) 
      FROM `tbl_event_packing_list` 
      JOIN `tbl_events` ON `tbl_events`.`event_id`=`tbl_event_packing_list`.`event_id` 
      WHERE ' . $data['date'].' <= DATE_ADD(STR_TO_DATE(`event_end`, "%Y-%m-%d"),INTERVAL 5 DAY))) as avaliableQuantity');

   $this->db->get('tbl_packing_list')->row();

Answer 1

$this->db->select('(从tbl_events.event_id=tbl_event_packing_list.event_id tbl_event_packing_list中选择SUM(packing_list_quantity) )，其中event_packing_item =‘.$data’.‘.’)-(‘.’.‘选择IFNULL(和(tbl_event_packing_list.packing_list_quantity)，0)，从tbl_event_packing_list JOIN tbl_events中选择event_packing_item’。$ <= DATE_ADD(STR_TO_DATE(event_end，"%Y-%m-%d")，间隔5天)和tbl_event_packing_list.event_packing_item =‘$data’‘id.’)；$this->db->where(‘event_item，$data’‘id’)；

Answer 2

可能是您在where子句中有更多的5天后尝试：

$data['date'].' <= DATE_ADD(STR_TO_DATE(`event_end`, "%Y-%m-%d"),INTERVAL 5 DAY)) as avaliableQuantity')