duanmangxie7131 2015-10-31 11:49
浏览 6

too long

$qurym="SELECT * FROM referal_member WHERE `ref_cusid` = '$id' && `confirm` = '1'";
$resm=mysqli_query($con,$qurym);
$rowm=mysqli_fetch_array($resm);
  • 写回答

2条回答 默认 最新

  • dongqiangou5724 2015-10-31 11:54
    关注

    Just try like this: [ if fields ( ref_cusid and confirm) are of INT type, then pass values $id and 1 without single quotes ( ' ), otherwise make change as below ]

    $qurym = "SELECT * FROM referal_member 
              WHERE `ref_cusid` = ' " . $id . "' 
              AND `confirm` = '1'";
    
    $resm = mysqli_query($con,$qurym);
    // check query returns something or not
    if(mysqli_num_rows($resm)){
     // fetch data 
      $rowm=mysqli_fetch_array($resm);
    }
    else{
     // no data found
    }
    
    评论

报告相同问题?

悬赏问题

  • ¥15 unity第一人称射击小游戏,有demo,在原脚本的基础上进行修改以达到要求
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
  • ¥15 关于#Java#的问题,如何解决?
  • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
  • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
  • ¥15 cmd cl 0x000007b
  • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
  • ¥500 火焰左右视图、视差(基于双目相机)
  • ¥100 set_link_state
  • ¥15 虚幻5 UE美术毛发渲染