MySQL在PHP中选择单列作为单维数组 [英] mysql select single column as single dimension array in PHP

问题描述

我正在从我的mysql数据库中选择一个列:

I'm selecting a single column from my mysql database:

$savedSQL = 'SELECT can_id FROM savedsearches WHERE user_id = "'.mysql_real_escape_string($user_id).'" AND insertTime >= "'.$lastSigTime.'"';
$savedQuery = mysql_query($savedSQL);

我想将值作为一维返回，枚举数组，例如array [0] = row1，array [1] = row2，等等.

And I'd like to return the values as a single dimension, enumerated array such that array[0] = row1, array[1] = row2, etc.

当我将其放入这样的数组中时:

When I put it into an array like this:

while($savedResult = mysql_fetch_array($savedQuery))
    {   $savedArray[] = $savedResult;   }

它以多维数组形式返回，因此array [0] [0] = row1，array [1] [0] = row2，依此类推.

It returns it as a multi-dimension array so that array[0][0] = row1, array[1][0] = row2, etc.

我正在考虑添加如下内容:

I was thinking of adding something like this:

while($i=0;$i<count($savedArray);$i++)
{
 $newSavedArray[$i] = $savedArray[$i][0]
}

但是有没有更简单，更有效的方法来完成此任务?

But is there an easier, more efficient way to accomplish this?

推荐答案

您非常亲密.您只需要访问 $ savedResult [0] 即可检索您的列，并将其附加到 $ savedArray

You're very close. You just need to access $savedResult[0] to retrieve your column, and append it onto $savedArray

while($savedResult = mysql_fetch_array($savedQuery)) {
  $savedArray[] = $savedResult[0];
}

这篇关于MySQL在PHP中选择单列作为单维数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！