Edit report at http://bugs.php.net/bug.php?id=54008&edit=1
ID: 54008 Comment by: lkzwieder at hotmail dot com Reported by: lucas dot tettamanti at gmail dot com Summary: mysql_fetch_assoc() expects parameter 1 to be resource Status: Bogus Type: Bug Package: MySQL related Operating System: Linux Mint 10 (Julia) PHP Version: 5.3.5 Block user comment: N Private report: N New Comment: p.tamaño ---> change the name of this field in database... I'm sure that the query works fine in MySql, but PHP doesn't accept ñ in the key of an array. Thats the problem... Previous Comments: ------------------------------------------------------------------------ [2011-02-13 18:02:52] ka...@php.net You need to check the return value of mysql_query() for errors as it won't magically emit one -> Bogus. ------------------------------------------------------------------------ [2011-02-13 17:17:59] lucas dot tettamanti at gmail dot com Description: ------------ If I change the current 'SELECT' to 'SELECT * FROM...' the script works fine. Otherwise PHP shows me the follow warning: Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /opt/lampp/htdocs/distri/functions.php on line 158 Test script: --------------- function get_productos($link,$params = null){ $query = "SELECT p.id, p.codigo, p.nombre, f.nombre as familia, pro.nombre as provedor, p.precio, p.tamaño, p.medida FROM productos p INNER JOIN familias f ON p.familia = f.id INNER JOIN provedores pro ON p.provedor = pro.id"; $result = mysql_query($query, $link); $i = 0;$productos = array(); while($data = mysql_fetch_assoc($result)){ foreach($data as $key => $valor){ $productos[$i][$key] = $valor; } $i++; } mysql_close($link); return $productos; } Expected result: ---------------- I expect fill the array $prod with data. Actual result: -------------- Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /opt/lampp/htdocs/distri/functions.php on line 158 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=54008&edit=1