Foreach "invalid argument"

[Neumy]

I've run into an interesting problem and hope someone can figure this out.

I have a simple sql statement that is gathering some data.
I then "foreach" through the results dumping out the values.

As far as I can tell everything works beautifully. I've tested this on every machine I can get a hold of and never received any problems. However, a client from Germany has constantly reported that he is receiving an error caused from this foreach statement:
"Warning: Invalid argument supplied for foreach() in /....setup.inc on line 65"

I've tried everything to duplicate the error here, but with no luck. He's not making this up, because when I change the code he correctly points to the same line. I've tried to cover up the error by using "Error Suppression" (the @) but I can't seem to get this working with a foreach statement.

Does anyone have ANY suggestions to help me out? I'd really appreciate it! Thanks 😃

[planetsim]

Can you show us the foreach line.

More than likely you have an associate array and using the foreach like this

foreach ($array as $value)

When it should be

foreach ($array as $key => $value)

[Neumy]

Sure, here's my code:

$results = func_query("SELECT primaryColor, secondaryColor, fontColor FROM template WHERE acronym = '$acronym';");
$m = 0; 
foreach ($results[0] as $val) 
    if ($m++%2) $main_template[] = $val;

I use the ($m++%2) because the $results array has:
[0] => "#961B43"
[primaryColor] => "#961B43"
[1] => "#000000"
[secondaryColor] => "#000000"
...
And I only want the [0], [1], [2] .... elements.

[laserlight]

And I only want the [0], [1], [2] .... elements.[/quopte]
Your database abstraction layer appears to be returning a combined associative and numeric indexed array for func_query().
This is similiar to mysql_fetch_array() in PHP's own API.
Does your DB abstraction layer have an equivalent of mysql_fetch_row(), which returns only a numeric indexed array?

Aside from that, there's an obvious problem with your code - you perform no error checking.