doormen2014 2016-09-22 12:00
浏览 256
已采纳

如何将多个值添加到同一个数组中

I want to show information on my page regarding multiple queries, each of them representing project status. To do that, i made a while loop, that adds information to an array.

The problem with that, is that i only show one of the statuses available, only the first one. Here is my code:

$exec = mysql_query($queryOntime) or trigger_error(mysql_error());
$exec1 = mysql_query($queryDelayed) or trigger_error(mysql_error());
$exec2 = mysql_query($queryPending) or trigger_error(mysql_error());        

$array_dados = array();

// All chart data
while($info = mysql_fetch_array($exec)||$info1 = mysql_fetch_array($exec1)||$info2 = mysql_fetch_array($exec2)){    
    $array_dados[] = $info; 
    $array_dados[] = $info1;
    $array_dados[] = $info2;                    
}   
return $array_dados;    

So as you can see, i have 3 queries, and i try adding all of them into an array, yet only one of the $info shows up. Why is that?

EDIT:

I removed the OR and separated my Fetch arrays, yet it still only shows the "Pending" one. Here's how it looks right now:

$exec = mysql_query($queryPending) or trigger_error(mysql_error());
$exec1 = mysql_query($queryOntime) or trigger_error(mysql_error());
$exec2 = mysql_query($queryDelayed) or trigger_error(mysql_error());    

$array_dados = array();

//All chart data
while($info = mysql_fetch_array($exec)) 
    $array_dados[] = $info; 

while($info1 = mysql_fetch_array($exec1))
    $array_dados[] = $info1;

while($info2 = mysql_fetch_array($exec2))
    $array_dados[] = $info2;

return $array_dados;
  • 写回答

1条回答 默认 最新

  • douhuang2282 2016-09-22 12:04
    关注

    You could do like this also..

    $exec = mysql_query($queryOntime) or trigger_error(mysql_error());
    $exec1 = mysql_query($queryDelayed) or trigger_error(mysql_error());
    $exec2 = mysql_query($queryPending) or trigger_error(mysql_error());        
    
    $array_dados = array();
    
    // All chart data
    while($info = mysql_fetch_array($exec) && $info1 = mysql_fetch_array($exec1) && $info2 = mysql_fetch_array($exec2)){    
        $array_dados[] = $info; 
        $array_dados[] = $info1;
        $array_dados[] = $info2;                    
    }   
    return $array_dados;
    

    Hope this would help.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 如何让企业微信机器人实现消息汇总整合
  • ¥50 关于#ui#的问题:做yolov8的ui界面出现的问题
  • ¥15 如何用Python爬取各高校教师公开的教育和工作经历
  • ¥15 TLE9879QXA40 电机驱动
  • ¥20 对于工程问题的非线性数学模型进行线性化
  • ¥15 Mirare PLUS 进行密钥认证?(详解)
  • ¥15 物体双站RCS和其组成阵列后的双站RCS关系验证
  • ¥20 想用ollama做一个自己的AI数据库
  • ¥15 关于qualoth编辑及缝合服装领子的问题解决方案探寻
  • ¥15 请问怎么才能复现这样的图呀