dtudj42064 2018-12-03 19:01
浏览 31

为什么我的SQL查询导致PHP数组缺少一半的结果?

My SQL query is

"select stat_name, stat_count 
from directors_stats 
where (id  = 1 or id =2) 
order by id";

It returns two rows like stat1: 123 and stat2: 456 yet when I execute it in my php script as follows:

while($raw = mysqli_fetch_array($result))
{
    print_r($raw);
}

The resulting array is

[0] => stat2
[stat_name] => stat2
[1] => 456
[stat_count] => 456

It looks like mysqli_fetch_array is returnng only the second row, but twice.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用EMD去噪处理RML2016数据集时候的原理
    • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大
    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 seatunnel 怎么配置Elasticsearch
    • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
    • ¥15 (标签-MATLAB|关键词-多址)
    • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
    • ¥500 52810做蓝牙接受端