[RESOLVED] numerical array, or associative array?

[Hexxx]

I'm still having problems telling (and coding the difference), though I know the associative array, indexes without numbers.

This was my line of code

while ($row = mysql_fetch_array ($result,MYSQL_ASSOC) )
{
    	$viewers_home_ids[$row['viewer_id']] = $row['viewer_home_id'];
}

And this was its result with print_r

Array
(
    [1] => 1
    [2] => 1
    [3] => 0
    [4] => 2
    [5] => 4
    [6] => 2
    [8] => 2
)

Is my array associative or not? And when arrays are associtive, how can I access a specific element in it directly? like array[6], I usually use foreach with my associative array, but I now have a situation where I don't want to go through the entire array to find a specific element.

[Roger_Ramjet]

Yes, your array is assoc - that is why you can code $row['viewer_id'].

Your code is creating an indexed array because $row['viewer_id'] resolves into an integer which PHP then uses as the index in the array you are creating.

If you just coded mysql_fetch_array($result) then you would get a combined array which is both indexed and associative. You could then refer to elements of $row by both name and index. If you use the MYSQL_ASSOC parameter then you will not get the numeric index and have to use key names.

[Hexxx]

I am using MYSQL_ASSOC in the code above. But I would have to know the actualy viewer_id that would be in the array? Because I am trying that and not getting through.
This is what I have from sql

+-----------+----------------+
| viewer_id | viewer_home_id |
+-----------+----------------+
|         1 |              1 |
|         2 |              1 |
|         3 |              0 |
|         4 |              2 |
|         5 |              4 |
|         6 |              2 |
|         8 |              2 |
+-----------+----------------+

I have another array called day_array_of_home_ids which contains viewer_ids, I need to use that table above from SQL and replace each viewer_id with the corresponding viewer_home_id. This is the code I am trying below, and I am getting "Warning: Illegal offset type in C:\wamp\www\web2\station_ssph.php on line 332"

								foreach ($day_array_of_home_ids as &$c) 
	{
	    foreach ($c as $k => &$v ) // v is in array of viewer_ids for sure
		$v = $viewers_home_ids[$v] ; //this is line 332

}

[Hexxx]

Ok never mind, some print_r and echo solves the problem, I still had to go another level deep to get inside the viewer_id array. Thanks!