Im receiving the following error:
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given
Asked
Active
Viewed 44 times
-2
Jacob
- 35
- 8
-
Is store a string or an integer? – Ali Jan 29 '15 at 20:02
-
1Put `mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in` into the search field. Then hit enter. – Sverri M. Olsen Jan 29 '15 at 20:09
-
please verify that you have the proper mysql connection in place!! – Kumar Saurabh Sinha Jan 29 '15 at 20:09
-
also please check if $store is an int or string value!! – Kumar Saurabh Sinha Jan 29 '15 at 20:10
-
1**Please, [stop using `mysql_*` functions](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php).** They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). **Learn about [prepared statements](http://en.wikipedia.org/wiki/Prepared_statement)** instead, and **use [PDO](http://us1.php.net/pdo).** – Jay Blanchard Jan 29 '15 at 20:12
-
@SaurabhSinha $store is a string, The connection works as all my other queries work. – Jacob Jan 29 '15 at 20:22
-
*"`$store` is a string"* - Treat it as one then. – Funk Forty Niner Jan 29 '15 at 21:25
2 Answers
0
$getholidaysisnt the result ofgetholidayrequest()
or
- from the documentation:
mysql_query() will also fail and return FALSE if the user does not have permission to access the table(s) referenced by the query
Bartłomiej Wach
- 1,968
- 1
- 11
- 17
-
-
you need to check the `mysql_error()` then as @OussamaELGOUMRI said – Bartłomiej Wach Jan 29 '15 at 20:03
-
-
1you should close $store in quotes if its a string "SELECT * FROM `holidays` WHERE `store` = '$store'"; – Bartłomiej Wach Jan 29 '15 at 21:03
0
you should check the mysql_query return value
$result = mysql_query('SELECT * WHERE 1=1');
if (!$result) {
die('Requête invalide : ' . mysql_error());
}
Oussama Elgoumri
- 609
- 1
- 5
- 15