what kind of an array will mysql_fetch_array($result) fetch?

Question

I want to fetch values from a table in a MySQL database into PHP.

What kind of array will mysql_fetch_array($result) return? Associative or numeric?

Easily answered by testing it out yourself or checking the manual, right? — No Results Found
– No Results Found, Commented Oct 21, 2011 at 6:36

xdazz · Accepted Answer · 2011-10-21 06:41:52Z

4

array mysql_fetch_array ( resource $result [, int $result_type = MYSQL_BOTH ] )

It depends on the second parameter which is default MYSQL_BOTH and could be MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH.

answered Oct 21, 2011 at 6:36

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

Comments

ariefbayu · Accepted Answer · 2011-10-21 06:36:30Z

3

From the manual:

mysql_fetch_array — Fetch a result row as an associative array, a numeric array, or both

answered Oct 21, 2011 at 6:36

ariefbayu

22k13 gold badges73 silver badges93 bronze badges

Did you read the manual yourself? Compare with xdazz's answer

@WesleyMurch if that's the case, I agree. Because it's typo and it's my fault.

Matteo Riva · Accepted Answer · 2011-10-21 06:36:48Z

1

It returns an array with both numeric and string indexes.

answered Oct 21, 2011 at 6:36

Matteo Riva

25.1k13 gold badges75 silver badges105 bronze badges