mysql_result（）期望参数1是资源，布尔给定[重复]

Question

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

I think the title says everything.

Here's my code:

function user_count(){
    $query = "SELECT COUNT * FROM  users  WHERE  active = 1";
    $result = mysql_query($query);
    return mysql_result($result, 0);
}

With this function. I'm trying to get all the users from the database who are "active"... All is OK with db connection and that stuff.

Answer 1

function user_count(){
    $query = "SELECT COUNT(user_id) FROM  `users` WHERE  `active` = 1";
    $result = mysql_query($query) or die($query."<br/><br/>".mysql_error());
    return mysql_result($result, 0);
}

This works.