PHP mysql_fetch_array error

Question

$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);

if(isset($username)){

    $queryIsUsername = ("SELECT count(user) FROM users WHERE user = '$username'");
    $actionQueryIsUsername = mysql_query($queryIsUsername);
    while($rowIsUsername = mysql_fetch_array($actionQueryIsUsername)) {
        $isUsername[] = $rowIsUsername['COUNT(user)'];
    }

    if($isUsername[0]="0"){

        header("Location: login.php?error=e1");
    }

I have checked the MySQL database, it is online. I have checked the query it does work. I'm not sure whats going on, i've done this a lot. The error is as follows.

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/craftlist/index.php on line 12

Actually no, because the answer is that the query does not work, my query does work. — Ozair Patel, May 09 '13 at 01:35
There is no more support for mysql_* functions, they are officially deprecated, no longer maintained and will be removed in the future. You should update your code with PDO or MySQLi to ensure the functionality of your project in the future. — Schleis, May 09 '13 at 01:42
@Schleis Thanks but that wont fix my situation, I used the alias and it didnt work. — Ozair Patel, May 09 '13 at 01:45
turn mysql_query($queryIsUsername); into mysql_query($queryIsUsername) or die(mysql_error()); and update the results so we can see the actual error. — alexander7567, May 09 '13 at 01:47
Ah, I have my database name commented out for. Thanks @alexander7567 — Ozair Patel, May 09 '13 at 01:50
No problem :) I had the same problem a while back and found out on here to do that lol — alexander7567, May 09 '13 at 01:51
Ah, @alexander7567 my config.php does select the database? '$sql_host = "localhost"; $sql_user = "root"; $sql_pass = ""; $sql_database = "craftlist"; $con = mysqli_connect("$sql_host","$sql_user","$sql_pass","$sql_database");' — Ozair Patel, May 09 '13 at 01:54
I've never used mysqli but try changing mysqli_connect("$sql_host","$sql_user","$sql_pass","$sql_database") to die(mysql_error()); and see what you get — alexander7567, May 09 '13 at 02:00
can you copy and paste the exact error you are getting on the mysql_query($queryIsUsername) or die(mysql_error()); line — alexander7567, May 09 '13 at 02:12
i see i made a typo... did you put... "mysqli_connect("$sql_host","$sql_user","$sql_pass","$sql_database") to die(mysql_error());" OR "mysqli_connect("$sql_host","$sql_user","$sql_pass","$sql_database") or die(mysql_error());" — alexander7567, May 09 '13 at 02:32

score 0 · Accepted Answer · answered May 09 '13 at 01:52

0

Make sure

You're selecting the database
You're selecting the right column name
You have single quotes where needed.

answered May 09 '13 at 01:52

Ryan

390
1
3
15

score 0 · Answer 2 · answered May 09 '13 at 02:05

When you are getting errors like this:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/craftlist/index.php on line 12

then that means you have an error in your mysql_query. To see what the real error is use:

mysql_query() or die(mysql_error());

PHP mysql_fetch_array error

2 Answers2