From:
Operating system: Linux Mint 10 (Julia)
PHP version: 5.3.5
Package: MySQL related
Bug Type: Bug
Bug description:mysql_fetch_assoc() expects parameter 1 to be resource
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 bug report at http://bugs.php.net/bug.php?id=54008&edit=1
--
Try a snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=54008&r=trysnapshot52
Try a snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=54008&r=trysnapshot53
Try a snapshot (trunk):
http://bugs.php.net/fix.php?id=54008&r=trysnapshottrunk
Fixed in SVN:
http://bugs.php.net/fix.php?id=54008&r=fixed
Fixed in SVN and need be documented:
http://bugs.php.net/fix.php?id=54008&r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=54008&r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=54008&r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=54008&r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=54008&r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=54008&r=support
Expected behavior:
http://bugs.php.net/fix.php?id=54008&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=54008&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=54008&r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=54008&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=54008&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=54008&r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=54008&r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=54008&r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=54008&r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=54008&r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=54008&r=mysqlcfg
