开发者

mysql_fetch_array and only string array keys

When I try to print_r mysql_fetch_array of a sql query, I get this result.

Array
(
    [0] => 1
    [id] => 1
    [1] => 2011
   开发者_JAVA技巧 [publish_date] => 2011
    [2] => Posted
    [status] => Posted
    [3] => test
    [post_title] => test
    [4] =>  testy test test testtttttt
    [post_text] =>  testy test test testtttttt
    [5] => true
    [post_comments] => true
    [6] => 21
    [reviews] => 21
    [7] => 1
    [network_id] => 1
    [8] => 3
    [views] => 3
    [9] => 0
    [comments] => 0
)

All I want is only string array keys so how can I convert this result to that?

Array
(
    [id] => 1
    [publish_date] => 2011
    [status] => Posted
    [post_title] => test
    [post_text] =>  testy test test testtttttt
    [post_comments] => true
    [reviews] => 21
    [network_id] => 1
    [views] => 3
    [comments] => 0
)


Use mysql_fetch_assoc


instead of mysql_fetch_array use mysql_fetch_assoc. thats it.


Use mysql_fetch_assoc function

or

Use second parameter for mysql_fetch_array function: MYSQL_ASSOC

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜