localhost / web - problem in array

[deimon]

Hello, i have question about this ...


$stare = Array
(
[0] => [e-mail]
[1] => [e-mail]
)

------

$sql = mysql_query("SELECT objekty.nazev, objekty.email, objekty.expirace, firmy.email as femail FROM firmy, objekty WHERE firmy.id = objekty.idfirmy GROUP BY objekty.email ORDER BY ".$ord);
while ($q = mysql_fetch_array($sql)){ $a = 0;
foreach($stare as $l){ if(($l == $q['email']) OR ($l == $q['femail'])) {$a = 1; break;} else $a = 0; }
if($a == 1) $prava[$q['email']] = $q['nazev']." - ".$q['expirace'];
else $leva[$q['email']] = $q['nazev']." - ".$q['expirace']; }
print_r($prava);

------

On web :........

Array
(
[0] => [e-mail]
[1] => [e-mail]
[[e-mail]] => Absolutum - 2011-01-31
[[e-mail]] => Academic hotel & Congress centre - 2009-05-30
)

On localhost ....

Array
(
[[e-mail]] => Absolutum - 2011-01-31
[[e-mail]] => Academic hotel & Congress centre - 2009-05-30
)


do you know where can be problem ?

[coopster]

Are you certain you are using the same fetch method on both servers? mysql_fetch_array [php.net] and the other mysql fetch methods can return the associative index, numerical index, or in the case of mysql_fetch_array, both. That's what it looks like to me.

[deimon]

yes all codes, all databases are same. but if I send script od server nr 1 ... output is Array
(
[0] => [e-mail]
[1] => [e-mail]
[[e-mail]] => Absolutum - 2011-01-31
[[e-mail]] => Academic hotel & Congress centre - 2009-05-30
)

now i test second webserver on other server .. and problem isn't there .. output is :

Array
(
[[e-mail]] => Absolutum - 2011-01-31
[[e-mail]] => Academic hotel & Congress centre - 2009-05-30
)

... as on my PC (localhost)


100% it must be settings of apache or php..

[Readie]

It'll be the settings of your PC that are at fault.

The results on your local PC appear to be the results from mysql_fetch_assoc [uk3.php.net] - however mysql_fetch_array should contain a mysql_fetch_assoc return and a mysql_fetch_row [uk2.php.net]