你是用echo $s来看的吗?
如果是这样$s语句被截断那应该是你程序有问题导致$s不完整,而不是SQL超长的问题.

解决方案 »

  1.   

    应该是字符串超长,因为我把sql字符串注释掉一部分,就可以!我的赋值语句如下:
    $sql = "insert into jy_zxqk(fareaid,fssdwid,fxmid,ftbrq,ftbr,fczrq,fczr,fxmlb,fssdwmc,fxmmc,ffzr,flxdh,fzxxs,fzzjzg,
       fzjsy_hj_1,fzjsy_hj_2,fzjsy_hj_3,fzjsy_hj_4,fzjsy_hj_5,fzjsy_hj_6,fzjsy_hj_7,fzjsy_hj_8,fzjsy_hj_9,fzjsy_hj_10,fzjsy_hj_11,fzjsy_hj_12,fzjsy_hj_13,fzjsy_hj_14,
       fzjsy_zy_1,fzjsy_zy_2,fzjsy_zy_3,fzjsy_zy_4,fzjsy_zy_5,fzjsy_zy_6,fzjsy_zy_7,fzjsy_zy_8,fzjsy_zy_9,fzjsy_zy_10,fzjsy_zy_11,fzjsy_zy_12,fzjsy_zy_13,fzjsy_zy_14,
       fzjsy_s_1,fzjsy_s_2,fzjsy_s_3,fzjsy_s_4,fzjsy_s_5,fzjsy_s_6,fzjsy_s_7,fzjsy_s_8,fzjsy_s_9,fzjsy_s_10,fzjsy_s_11,fzjsy_s_12,fzjsy_s_13,fzjsy_s_14,
       fzjsy_d_1,fzjsy_d_2,fzjsy_d_3,fzjsy_d_4,fzjsy_d_5,fzjsy_d_6,fzjsy_d_7,fzjsy_d_8,fzjsy_d_9,fzjsy_d_10,fzjsy_d_11,fzjsy_d_12,fzjsy_d_13,fzjsy_d_14,
       fzjsy_x_1,fzjsy_x_2,fzjsy_x_3,fzjsy_x_4,fzjsy_x_5,fzjsy_x_6,fzjsy_x_7,fzjsy_x_8,fzjsy_x_9,fzjsy_x_10,fzjsy_x_11,fzjsy_x_12,fzjsy_x_13,fzjsy_x_14,
       fzjsy_qt_1,fzjsy_qt_2,fzjsy_qt_3,fzjsy_qt_4,fzjsy_qt_5,fzjsy_qt_6,fzjsy_qt_7,fzjsy_qt_8,fzjsy_qt_9,fzjsy_qt_10,fzjsy_qt_11,fzjsy_qt_12,fzjsy_qt_13,fzjsy_qt_14,
               fkgrq,fwgrq,fysrq,ftyrq,fxmjzqk,
    flhzb_jh_1,flhzb_jh_2,flhzb_jh_3,flhzb_jh_4,flhzb_jh_5,flhzb_jh_6,flhzb_jh_7,flhzb_jh_8,flhzb_jh_9,flhzb_jh_10,flhzb_jh_11,
    flhzb_sj_1,flhzb_sj_2,flhzb_sj_3,flhzb_sj_4,flhzb_sj_5,flhzb_sj_6,flhzb_sj_7,flhzb_sj_8,flhzb_sj_9,flhzb_sj_10,flhzb_sj_11,fbz)
     values('$fareaid','$fssdwid','$fxmid',convert(datetime,'$ftbrq',120),'$ftbr',convert(datetime,'$fczrq',120),'$fczr','$fxmlb','$fssdwmc','$fxmmc','$ffzr','$flxdh','$fzxxs','$fzzjzg',
    '$fzjsy_hj_1','$fzjsy_hj_2','$fzjsy_hj_3','$fzjsy_hj_4','$fzjsy_hj_5','$fzjsy_hj_6','$fzjsy_hj_7','$fzjsy_hj_8','$fzjsy_hj_9','$fzjsy_hj_10','$fzjsy_hj_11','$fzjsy_hj_12','$fzjsy_hj_13','$fzjsy_hj_14',
    '$fzjsy_zy_1','$fzjsy_zy_2','$fzjsy_zy_3','$fzjsy_zy_4','$fzjsy_zy_5','$fzjsy_zy_6','$fzjsy_zy_7','$fzjsy_zy_8','$fzjsy_zy_9','$fzjsy_zy_10','$fzjsy_zy_11','$fzjsy_zy_12','$fzjsy_zy_13','$fzjsy_zy_14',
    '$fzjsy_s_1','$fzjsy_s_2','$fzjsy_s_3','$fzjsy_s_4','$fzjsy_s_5','$fzjsy_s_6','$fzjsy_s_7','$fzjsy_s_8','$fzjsy_s_9','$fzjsy_s_10','$fzjsy_s_11','$fzjsy_s_12','$fzjsy_s_13','$fzjsy_s_14',
    '$fzjsy_d_1','$fzjsy_d_2','$fzjsy_d_3','$fzjsy_d_4','$fzjsy_d_5','$fzjsy_d_6','$fzjsy_d_7','$fzjsy_d_8','$fzjsy_d_9','$fzjsy_d_10','$fzjsy_d_11','$fzjsy_d_12','$fzjsy_d_13','$fzjsy_d_14',
    '$fzjsy_x_1','$fzjsy_x_2','$fzjsy_x_3','$fzjsy_x_4','$fzjsy_x_5','$fzjsy_x_6','$fzjsy_x_7','$fzjsy_x_8','$fzjsy_x_9','$fzjsy_x_10','$fzjsy_x_11','$fzjsy_x_12','$fzjsy_x_13','$fzjsy_x_14',
    '$fzjsy_qt_1','$fzjsy_qt_2','$fzjsy_qt_3','$fzjsy_qt_4','$fzjsy_qt_5','$fzjsy_qt_6','$fzjsy_qt_7','$fzjsy_qt_8','$fzjsy_qt_9','$fzjsy_qt_10','$fzjsy_qt_11','$fzjsy_qt_12','$fzjsy_qt_13','$fzjsy_qt_14',";$sql.="convert(datetime,'$fkgrq',120),convert(datetime,'$fwgrq',120),convert(datetime,'$fysrq',120),convert(datetime,'$ftyrq',120)','$fxmjzqk','$flhzb_jh_1','$flhzb_jh_2','$flhzb_jh_3','$flhzb_jh_4','$flhzb_jh_5','$flhzb_jh_6','$flhzb_jh_7','$flhzb_jh_8','$flhzb_jh_9','$flhzb_jh_10','$flhzb_jh_11','$flhzb_sj_1','$flhzb_sj_2','$flhzb_sj_3','$flhzb_sj_4','$flhzb_sj_5','$flhzb_sj_6','$flhzb_sj_7','$flhzb_sj_8','$flhzb_sj_9','$flhzb_sj_10','$flhzb_sj_11,'$fbz')";然后把$sql作为参数传入执行
      

  2.   


    你用addslashes($url)然后输入看看有没被截取,如果没可能你的语句中有问题。要不你再用'insert into a values(.....)';试试。
      

  3.   

    我发现是因为后面的变量不存在!
    post是否有限制??导致从$flhzb_jh_1后面的变量都没有?
      

  4.   

    试试 $sql = "insert into jy_zxqk set fareaid='$fareaid',fssdwid='$fssdwid', ......
      

  5.   

    不如insert几个少的?然后update
    好像是个馊主意
    不过为了检查错误,还是可行的哦