php 里一个sql语句太长，调式时发现sql语句变得不完整了

来源：互联网发布：mac桌面路径命令编辑：程序博客网时间：2024/04/29 11:58

PHP高手们，帮我解决一个问题吧：
在php里定义了一条sql如下：
$sql = "SELECT * FROM p_info pi LEFT JOIN job j ON j.id = " . $id .
"WHERE pi.requestid = 0
AND ((ifnull(pi.standard_20_ft_container, 0) - ifnull(j.standard_20_ft_container, 0)) <= 0)
AND ((ifnull(pi.standard_40_ft_container, 0) - ifnull(j.standard_40_ft_container, 0)) <= 0)
AND ((ifnull(pi.high_cube_40_ft_container, 0) - ifnull(j.high_cube_40_ft_container, 0)) <= 0)
AND ((ifnull(pi.capacity_head_of_cattle, 0) - ifnull(j.capacity_head_of_cattle, 0)) <= 0)
AND ((ifnull(pi.capacity_head_of_sheep, 0) - ifnull(j.capacity_head_of_sheep, 0)) <= 0)
AND ((ifnull(pi.capacity_other_livestock, 0) - ifnull(j.capacity_other_livestock, 0)) <= 0)
AND ((ifnull(pi.capacity_number_of_horses, 0) - ifnull(j.capacity_number_of_horses, 0)) <= 0)
AND ((ifnull(pi.grain_feed_kg, 0) - ifnull(j.carrying_capacity_kg, 0)) <= 0)
AND ((ifnull(pi.length_cm, 0) - ifnull(j.tray_length_cm, 0)) <= 0)
AND ((ifnull(pi.width_cm, 0) - ifnull(j.tray_width_cm, 0)) <= 0)
AND ((ifnull(pi.height_cm, 0) - ifnull(j.max_load_height_cm, 0)) <= 0)
AND ((ifnull(pi.weight_kg, 0) - ifnull(j.carrying_capacity_kg, 0)) <= 0)
AND to_days(j.home_day1) <= to_days(str_to_date(pi.date1, '%d/%m/%Y'))
AND to_days(str_to_date(pi.date2, '%d/%m/%Y')) <= to_days(j.home_day2)
但是查询出的数据为空，调式时发现，传到$query = mysql_query ( $sql );这里的sql语句变成这样了：
SELECT * FROM p_info pi LEFT JOIN job j ON j.id = 734WHERE pi.requestid = 0
AND ((ifnull(pi.standard_20_ft_container, 0) - ifnull(j.standard_20_ft_container, 0)) <= 0)
AND ((ifnull(pi.standard_40_ft_container, 0) - ifnull(j.standard_40_ft_container, 0)) <= 0)
AND ((ifnull(pi.high_cube_40_ft_container, 0) - ifnull(j.high_cube_40_ft_container, 0)) <= 0)
AND ((ifnull(pi.capacity_head_of_cattle, 0) - ifnull(j.capacity_head_of_cattle, 0)) <= 0)
AND ((ifnull(pi.capacity_head_of_sheep, 0) - ifnull(j.capacity_head_of_sheep, 0)) <= 0)
AND ((ifnull(pi.capacity_other_livestock, 0) - ifnull(j.capacity_other_livestock, 0)) <= 0)
AND ((ifnull(pi.capacity_number_of_horses, 0) - ifnull(j.capacity_number_of_horses, 0)) <= 0)
AND ((ifnull(pi.grain_feed_kg, 0) - ifnull(j.carrying_capacity_kg, 0)) <= 0)
AND ((ifnull(pi.length_cm, 0) - ifnull(j.tray_length_cm, 0)) <= 0)
AND ((ifnull(pi.width_cm, 0) - ifnull(j.tray_width_cm, 0)) <= 0)
AND ((ifnull(pi.height_cm, 0) - ifnull(
貌似后面的就被截断了，数据库里运行这个sql是没问题的。但是在这里就有问题，怎么办呢？大家有遇到这样问题吗？

0 0