mysql_fetch_array and only string array keys

Question

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

Array
(
    [0] => 1
    [id] => 1
    [1] => 2011
    [publish_date] => 2011
    [2] => Posted
    [status] => Posted
    [3] => test
    [post_title] => test
    [4] => &nbsp;testy test test testtttttt
    [post_text] => &nbsp;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] => &nbsp;testy test test testtttttt
    [post_comments] => true
    [reviews] => 21
    [network_id] => 1
    [views] => 3
    [comments] => 0
)

xdazz · Accepted Answer · 2011-09-16 05:29:42Z

5

Use mysql_fetch_assoc

answered Sep 16, 2011 at 5:29

xdazz

161k38 gold badges255 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Astha · Accepted Answer · 2011-09-16 05:29:46Z

2

instead of mysql_fetch_array use mysql_fetch_assoc. thats it.

answered Sep 16, 2011 at 5:29

Astha

1,7345 gold badges17 silver badges36 bronze badges

Comments

IvanGL · Accepted Answer · 2011-09-16 05:33:49Z

0

Use mysql_fetch_assoc function

or

Use second parameter for mysql_fetch_array function: MYSQL_ASSOC

answered Sep 16, 2011 at 5:33

IvanGL

7655 silver badges22 bronze badges

Collectives™ on Stack Overflow

mysql_fetch_array and only string array keys

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related