我有MySQL查询到列:SELECT column FROM table
。有没有可能将这个查询的结果保存到数组中?
我现在有这个代码:
$dotazHlasy = mysql_query("SELECT `id_ulohy` FROM `mproud-hlasy` WHERE `id_uzivatele`=".$_SESSION['uzivatel']) or die(mysql_error());
while($radek = mysql_fetch_row($dotazHlasy)){
$hlasy[] = $radek;
};
我收到的回复:
Array
(
[0] => Array
(
[0] => 4
)
[1] => Array
(
[0] => 3
)
)
我想要这个:
Array
(
[0] => 4
[1] => 3
)
谢谢你的建议。
将一列放入数组的最简单方法如下代码所示。
$YouArray = array();
$command = mysql_query("SELECT column FROM table");
while($result = mysql_fetch_array($command))
$YouArray[] = $result['column'];