3 Errors In My PHP Script?

Question

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

EDITED! Okay, I have like 3 Errors on my website. These are the errors that pop up. Connection Info:

$dbhost     = '127.0.0.1';
$dbdatabase = 'bans';
$dbuser     = 'dsfhalsfdh';
$dbpassword = 'lfhdjklfdf';
$webname    = 'InsanityRP.Com'

This are the errors:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/klayplex/public_html/insanityrp.com/bans/index.php on line 41

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/klayplex/public_html/insanityrp.com/bans/index.php on line 68

My Code Goes In Order:

                        $result = mysql_fetch_array(mysql_query($query));

Then

                        while($row=mysql_fetch_assoc($result)){

Anything look weird? I don`t know PHP at all, so if you can, please tell me what to edit or just give me the code to copy and paste.

That's coz mysql_query is failing and returning false. Where is your db connection code? — Dr. Dan, Dec 22 '12 at 08:50
@NateBowman Update that in the question, and, please format your question in a better way like this! — Praveen Kumar Purushothaman, Dec 22 '12 at 08:52
You have a typo `$resul1` pro `$result` in the initial assignment. — tripleee, Dec 22 '12 at 08:54
Actually, maybe *don't* update the question to include your MySQL username and password... — John Flatness, Dec 22 '12 at 08:56
Please note that **the old _mysql_ extension in PHP has been deprecated as of PHP 5.5.0 and will be removed in the future**. See [`mysql_query()`](http://php.net/manual/en/function.mysql-query.php) and http://stackoverflow.com/q/10696696/1402846. — Pang, Dec 22 '12 at 09:05
See http://stackoverflow.com/a/11674313/1402846 for more troubleshooting tips. — Pang, Dec 22 '12 at 09:12

score 1 · Answer 1 · answered Dec 22 '12 at 08:55

1

First one you've got $resul1 instead of $result
second error is because you're expecting results, but mysql_query() returns a boolean on error, so you've probably got an issue with your query
Finally your last query has the same typo as the first with $resul1 instead of $result.

answered Dec 22 '12 at 08:55

ernie

6,257
22
27

Fixed #1 and #3, but still got errors. How do I fix #2? Im a noob – Nate Bowman Dec 22 '12 at 08:59

score 1 · Answer 2 · answered Dec 22 '12 at 09:23

That's funny one.
You have an extra call to mysql_fetch_array, which returns an array, not a resource.

Also, go not try stuff as many operators as you can in one line like this

$result = mysql_fetch_array(mysql_query($query));

write them separately, along with some error checking

$query = "SELECT ...";
$result = mysql_query($query) or trigger_error(mysql_error()."[$query]");
while($row=mysql_fetch_assoc($result)){

Pang · Answer 3 · 2012-12-22T09:20:51.310

0

Your $result is misspelled as $resul1. It's a typo.

EDIT: mysql_query() returns false (which is a boolean) when it fails. Use mysql_error() to find out what the error was. I suggest you to rewrite

$result = mysql_fetch_array(mysql_query($query));

into

$resultSet = mysql_query($query);
print mysql_error();    // Print the error message.
$result = mysql_fetch_array($resultSet);

edited Dec 22 '12 at 09:20

answered Dec 22 '12 at 08:54

Pang

9,073
146
84
117

score 0 · Answer 4 · answered Dec 22 '12 at 08:54

0

while($row=mysql_fetch_assoc($resul1)){

to

while($row=mysql_fetch_assoc($result))

answered Dec 22 '12 at 08:54

Mudassir Hasan

26,910
19
95
126

Fixed, but no effect on target. – Nate Bowman Dec 22 '12 at 08:59

score 0 · Answer 5 · answered Dec 22 '12 at 08:58

0

Change $resul1 to $result and dont ask again like this questions.It will be difficult for catching problem with only that error.Consider using mysql_error() this can help finding the right problem.

answered Dec 22 '12 at 08:58

harikrishnan.n0077

1,757
4
19
27

2

did u try using mysql_error() – harikrishnan.n0077 Dec 22 '12 at 09:02

3 Errors In My PHP Script?

5 Answers5