Array
(
[0] => Array
(
[0] => 1
[id] => 1
[1] => 1
[candi_id] => 1
[2] =>
[title] =>
[3] => Lakshmanan
[firstname] => Lakshmanan
[4] => P
[lastname] => P
[5] => Male
[gender] => Male
[6] => Tamil
[mothertongue] => Tamil
[7] => 31-01-1990
[dob] => 31-01-1990
[8] => Hindu
[religion] => Hindu
[9] => O+
[bloodgroup] => O+
[10] => Single
[marital_status] => Single
[11] => Mettupalayam
[native] => Mettupalayam
[12] => Indian
[nationality] => Indian
[13] => Active
[status] => Active
[14] => 2016-11-04
[cdate] => 2016-11-04
)
)
我只想得到列值。但为什么我得到数组索引值?
首先我想说的是,mysql
函数是不赞成的。因此,现在继续使用mysqli
或PDO
对mysql
databse
功能更好。
不带参数的mysql_fetch_array
函数将输出index
和column-name
格式的DB
记录。
要获得column-name
数据,您应该在mysql_fetch_array
函数中传递第二个参数"MYSQL_ASSOC
",或者您也可以使用mysql_fetch_assoc
函数。
$result = mysql_fetch_assoc($mysql_query);