[HELP] Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in

[bodge]

Hello Devbest, I got an error while coding my function:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\Users\Owner\Desktop\Billy\xampp-win32-1.8.2-2-VC9\xampp\htdocs\Pony\includes\users.inc.php on line 23

I have no idea what to do :/

//Other functions above

function fetch_user_ids($user_names){
    foreach ($user_names as &$name){
        $name = mysql_real_escape_string($name);
    }
   
    $result = mysql_query("SELECT `id`, `username` FROM `users` WHERE `username` IN ('" . implode("', '", $user_names) . "')");
   
    $names = array();
   
    while (($row = mysql_fetch_assoc($result)) !== false){
        $names[$row['username']] = $row['id'];
    }
    return $names;
}

Thanks in advanced.

 

[Sysode]

Is there any data in your sql tables?

 

[bodge]

Is there any data in your sql tables?

Yes

(users table)

fixed, close pls

 

[RastaLulz]

Incase someone has this issue in the future, the reason why is giving an error is because of an error in the SQL syntax. You must remove the comma from the last item that is imploded.