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.

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

报告相同问题?

悬赏问题

  • ¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
  • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能