drc15469 2014-07-30 09:31
浏览 58

ACCESS SQL查询无法在PHP中运行

i have sql query it works with select * but when i put column names it does not show data.

$sql2="SELECT PSO_NAME, PSO_SIGNATURE, PSO_DATE FROM SIGNATURES_DASO WHERE DASO_NO ='".$daso_no."'";
echo $sql2; //it shows the query which i tested in access runs fine.
$rs_pso_sign=odbc_exec($conn,$sql2);
if (!$rs_pso_sign) {
  exit("Error in SIGNATURE TABLE INFO SQL");
}

if(odbc_fetch_row($rs_pso_sign)){

                $psoName = odbc_result($rs_pso_sign, "PSO_NAME");
                $psoSign = odbc_result($rs_pso_sign, "PSO_SIGNATURE");
                $psoDate = odbc_result($rs_pso_sign, "PSO_DATE");
                echo $psoName;
         }
else
 {
 echo "$psoName does not exist";
}

it works when i do

 $sql2="SELECT * FROM SIGNATURES_DASO WHERE DASO_NO ='".$daso_no."'";

i checked from database column names are the same no typo mistake as well.

any suggestions?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 有关区间dp的问题求解
    • ¥15 多电路系统共用电源的串扰问题
    • ¥15 slam rangenet++配置
    • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
    • ¥15 对于相关问题的求解与代码
    • ¥15 ubuntu子系统密码忘记
    • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
    • ¥15 保护模式-系统加载-段寄存器
    • ¥15 电脑桌面设定一个区域禁止鼠标操作
    • ¥15 求NPF226060磁芯的详细资料