Explore our sites

Stack Exchange
tour help careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select

I dedicated this question for those who have read book 'PHP For Absolute Beginners' (Apress, Jason Lengstorf). I got error when trying example on page 151 :

function.inc.php :

array_push($e, $fulldisp);
return $e;

index.php :

$fulldisp = array_pop($e);

You can view full code here - http://pastebin.com/bpjAbguM

And browser give error :

Warning: array_push() expects parameter 1 to be array, boolean given in C:\xampp\htdocs\simple_blog\inc\functions.inc.php on line 43

Warning: array_pop() expects parameter 1 to be array, boolean given in C:\xampp\htdocs\simple_blog\index.php on line 16

share|improve this question
1  
$e isn't an array - I think you need to work backwards from the error, doing a var_dump of $e so you can see what it contains and where it's being set. –  JoLoCo Oct 18 '11 at 22:05
 
you should var_dump($e) and var_dump($fulldisp) and see what's there –  user973254 Oct 18 '11 at 22:07
 
Just reading the error can give you a big hint, since you're a beginner i would get used to reading the errors and trying to figure out what's wrong. –  aziz punjani Oct 18 '11 at 22:07
 
This is the code pastebin.com/jWRRt4Cy I though $e already set as an array on line 35? –  Zhaf Oct 18 '11 at 22:10
add comment

marked as duplicate by casperOne♦ Aug 6 '12 at 11:19

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

3 Answers

up vote 0 down vote accepted

In the beginning of function place line $e = array() to make sure that $e is always array.

share|improve this answer
 
I'm sorry man, here's the code - pastebin.com/jWRRt4Cy not that one in the answer. –  Zhaf Oct 18 '11 at 22:09
 
I've updated answer –  Novakov Oct 18 '11 at 22:14
 
Thanks for your answer! –  Zhaf Oct 18 '11 at 22:33
add comment
up vote 0 down vote

Your query is set up wrong, you should be binding parameters where your execute call is, then calling execute() and $e should not be set to the result of fetch as that will return a boolean, not an array as you are expecting.

share|improve this answer
add comment
up vote 0 down vote

I see multiple pastes, but in paste http://pastebin.com/bpjAbguM you should change line 47

$e = $row;

into

$e[] = $row;

The first statement assignes the row to $e, while the second statement adds the row to the array $e.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.