display the mysql count function? [duplicate]

Question

$query = "select count(*)
                      from relationships
                      where leader = 'user_id'";
            $result = mysql_query($query);

how can i display the count? thanks

Answer 1

$count = mysql_fetch_array($result);
echo $count[0];