Trouble with associate arrays...

PHPist

Are someone know how parse the associate array what return when using mysql_fetch_array()?
It has a very strange structure, and I don't know have get elements from it without loop. I try to parsed this array with foreach() but it was not successful so I ask for your help.
Can someone told me what I must do ?

bradgrafelman

Well, what do you mean by "parse" ? Generally you just loop through the data in a [man]while/man loop and use it as necessary.

If you JUST want an associative array, I would recommend using [man]mysql_fetch_assoc/man, though the process is the same. Here's an example:

while($result = mysql_fetch_array($exec)) {
     echo 'Name: ' . $result['name'] . "<br>\n";
     echo 'Age: ' . $result['age'] . "<hr>\n";
}

If you're having a specific problem, show us the code you're using and explain what you're trying to do with it.

PHPist

But why necessary ?
You say that this type of arrays can't transformated to the simple indexed array (1=>value,2=>value) ?

bradgrafelman

I'm afraid I don't understand your question. Are you saying you just want to build an array of all of the rows for a single column in a MySQL table?

Weedpacket

PHPist wrote:
You say that this type of arrays can't transformated to the simple indexed array (1=>value,2=>value) ?

Of course it can. If you don't want to do it yourself you can use [man]mysql_fetch_array[/man] or one of its related functions to do that.

Ah, bradgrafelman might be a bit better at understanding the question.

Houdini

Maybe this explanation from the manual will help.

Returns an array that corresponds to the fetched row, or FALSE if there are no more rows. The type of returned array depends on how result_type is defined. By using MYSQL_BOTH (default), you'll get an array with both associative and number indices. Using MYSQL_ASSOC, you only get associative indices (as mysql_fetch_assoc() works), using MYSQL_NUM, you only get number indices (as mysql_fetch_row() works).

If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the same name, you must use the numeric index of the column or make an alias for the column. For aliased columns, you cannot access the contents with the original column name.

Source: Function - mysql_fetch_array()So if you want to use a numerical index then with no second parameter you can or you could use the MYSQL_NUM as the second parameter.

PHPist

Thanks to all. You very help me, guys !!!