Why do I get Warning: Mysql_fetch_array() expects parameter 1 to be resource, boolean given?

Question

I know this has been asked a million and one time but and I have read them, I can't seem to see what the problem is.

I'm using the select code from a w3 tutorial:

$con = mysql_connect("$server","#user","$admin");

if (!$con) {
  die('Could not connect: ' . mysql_error());
}

mysql_select_db("$db", $con);

$result = mysql_query("SELECT * FROM options");

while($row = mysql_fetch_array($result)) {
  echo $row['copy_right'];
}

mysql_close($con);

And then is displayed in:

<?php $FP->copy_right(); ?> if it matters,

The full error I get is:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/frontcms/app/core/core.php on line 112

This has been asked [4,937](http://stackoverflow.com/search?q=Warning%3A+Mysql_fetch_array%28%29+expects+parameter+1+to+be+resource%2C+boolean+given) so far! — Zuul, Oct 05 '12 at 02:08

score 1 · Accepted Answer · answered Oct 05 '12 at 02:07

1

"#user" sound like to be $user.

Add the error check will help you know what is wrong.

if (!$result) {
  die(mysql_error());
}

And note: Don't quote your variables.

$con = mysql_connect("$server","#user","$admin");

should just be

$con = mysql_connect($server, $user, $admin);

and

mysql_select_db("$db", $con);

should just be:

mysql_select_db($db, $con);

answered Oct 05 '12 at 02:07

xdazz

154,648
35
237
264

yea fixed that and will add the if – Denver Oct 05 '12 at 02:29
i get a no database selected error – Denver Oct 05 '12 at 02:36
1

@Denver So that is the problem. – xdazz Oct 05 '12 at 03:12
i have fixed it! thanks for your help! – Denver Oct 05 '12 at 03:20

John Woo · Answer 2 · 2012-10-05T02:03:05.020

0

try this,

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

See PHP Manual: mysql_fetch_array

edited Oct 05 '12 at 02:03

answered Oct 05 '12 at 01:57

John Woo

249,283
65
481
481

Why would this make any difference whatsoever? – Niet the Dark Absol Oct 05 '12 at 02:05

score 0 · Answer 3 · answered Oct 05 '12 at 02:00

0

i guess you have a typo error:

$con = mysql_connect("$server","#user","$admin");

#user should be $user

answered Oct 05 '12 at 02:00

sephoy08

1,076
7
16

was a error but in fact made no difference – Denver Oct 05 '12 at 02:27

Why do I get Warning: Mysql_fetch_array() expects parameter 1 to be resource, boolean given?

3 Answers3