mysql function fetch_我的数组（mysql_fetch_array）中的结果翻倍

好吧，我执行这个

$table = get_personel_table(1);

function get_personel_table($id)

{

global $connection;

$query = "SELECT * ";

$query .= "FROM employees ";

$query .= "WHERE id=" . $id . " ";

$query .= "ORDER BY id ASC";

$query_result = mysql_query( $query , $connection );

confirm_query($query_result);

$query_result_array = mysql_fetch_array($query_result);

return $query_result_array; // returns associative array!;

}

我做foreach

foreach($table as $table_var)

{

echo "

" . $table_var . "";

}

然后这样做，我得到了双重输出…“ 1 1 1 1 jordan jordan 9108121544 9108121544 testEmail

testEmail testAddress testAddress testCounty testCounty”

这是print_r的结果

Array

(

[0] => 1

[id] => 1

[1] => 1

[department_id] => 1

[2] => jordan

[name] => jordan

[3] => 9108121544

[EGN] => 9108121544

[4] => testEmail

[email] => testEmail

[5] => testAddress

[address] => testAddress

[6] => testCounty

[country] => testCounty

)

我在数据库中拥有的信息是id => 1，department_id => 1，依此类推…我的问题是为什么我会得到双重反馈(我不知道怎么称呼)，0 =

id，1 = department_id，2 =名称，依此类推。

当我做foreach(…)时，我得到的一切都会翻倍。