PHP Error: Function Name Must Be String

[majestyc]

Fatal error: Function name must be a string in /home/............ on line 4

<?php
function user_exists($username) {
    $username = sanitize($username);
    $query = $mysql_query ("SELECT COUNT('user_id') FROM 'majestyc_users' WHERE 'username' = '$username'");
    return (mysql_result($query, 0) == 1) ? true : false;
};
?>

I can't figure out why this is wrong.....can I please get some help? I've also tried the function name variation "userExists".

 

[majestyc]

Ok, I've figured out the problem and it wasn't with the "user_exists" it was where I put $mysql_query() on line 4. I've fixed it by putting just mysql_query() without the "$"

I also had to replace the '' marks with `` and remove the `` marks from WHERE `username` = '$username' to get it to work.

Here is the new code for it:

<?php
function user_exists($username) {
    $username = sanitize($username);
    $query = mysql_query("SELECT COUNT(`user_id`) FROM `majestyc_users` WHERE username = '$username'");
    return (mysql_result($query, 0) == 1) ? true : false;
};
?>