Strange error with PHP: mysql_fetch_array() expects parameter 1 to be resource, boolean given

Question

Normally, this kind of error shows up when trying to perform a mysql_fetch_array to a query that's faulty, however I am constantly getting this error despite the query is being performed (it's an insert, I can check the new entrances in phpmyadmin).

For example, the output for this:

$query= mysql_query("INSERT INTO `objects` (`idObjects`, `obj_type`, `obj_name`, `obj_cdate`, `availability`, `status`, `User_idUser`) VALUES (NULL, '$type', 'EL TESTE', '$final', 'Public', 'Active', '13')");
$insert_place = mysql_fetch_array($query, MYSQL_ASSOC);
if (!$insert_place) {
   die('Invalid query: ' . mysql_error());

is Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\neo4play\factualimport.php on line 22 Invalid query:

with no error provided, and that row is still inserted into the database. Any clue what might be causing this?

Inserts don't return arrays, and you should not use mysql_ functions in new development either. — developerwjk
– developerwjk, Commented Jun 27, 2014 at 20:45
Stop using mysql, it's deprecated and not secure. Use mysqli or PDO. — ElendilTheTall
– ElendilTheTall, Commented Jun 27, 2014 at 20:45

Scott Drinkwater · Accepted Answer · 2014-06-27 22:26:49Z

1

You can't fetch an INSERT query as it is not returning rows. You use mysql_fetch_array() with a SELECT statement to return an array of data from the query. Take out:

$insert_place = mysql_fetch_array($query, MYSQL_ASSOC);

and replace:

if (!$insert_place)

with:

if (!$query)

answered Jun 27, 2014 at 22:26

Scott Drinkwater

811 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Strange error with PHP: mysql_fetch_array() expects parameter 1 to be resource, boolean given

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related