dongxia026531 2014-03-27 04:25
浏览 7
已采纳

这个查询中有什么错误,不删除

I am using echo $fss its display data

"11-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V5703211-V57032"

but i am using delete query using this variable but its not working

<?php  

 //connect to the database 
 $connect = mysql_connect("localhost","root",""); 
 mysql_select_db("cityshoes",$connect); //select the table 


if ($_FILES[csv][size] > 0) { 

    //get the csv file 
    $file = $_FILES['csv']['tmp_name'];
    $handle = fopen($file,"r"); 



    do { 
        if ($data[0]) { 

 $fss = addslashes($data[1]);
        $result = mysql_query("DELETE from  contacts where articleno = . $fss . ");

        echo $fss;


        } 
    } while ($data = fgetcsv($handle,1000,",","'")); 



} 

?> 
  • 写回答

2条回答 默认 最新

  • douyue1481 2014-03-27 04:28
    关注

    You are appending variable in the query in wrong way. Try with:

    $result = mysql_query("DELETE from  contacts where articleno = $fss");
    

    or

    $result = mysql_query("DELETE from contacts where articleno ='".$fss ."'");
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
  • ¥20 关于URL获取的参数,无法执行二选一查询
  • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
  • ¥15 marlin编译错误,如何解决?
  • ¥15 有偿四位数,节约算法和扫描算法
  • ¥15 VUE项目怎么运行,系统打不开
  • ¥50 pointpillars等目标检测算法怎么融合注意力机制
  • ¥20 Vs code Mac系统 PHP Debug调试环境配置
  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集