3 table mysql

PHP kode 

 $sql = "SELECT * FROM answer INNER JOIN user ON answer.user_id = user.id";
 $query = mysql_query($sql) or die(mysql_error());
 
 $sql2 = "SELECT * FROM votes INNER JOIN user ON votes.user_id = user.id";
 $query2 = mysql_query($sql2) or die(mysql_error());
 
 $row = mysql_fetch_assoc($query);
 echo $row["navn"];
 
 $row2 = mysql_fetch_assoc($query2);
 echo mysql_num_rows($query2);

PHP kode 

 $sql = "SELECT answer.user_id, user.navn FROM answer INNER JOIN user ON answer.user_id = user.id";
 $query = mysql_query($sql) or die(mysql_error());
 $row = mysql_fetch_assoc($query);
 $userid = $row["user_id"];
 
 $sql2 = "SELECT * FROM votes INNER JOIN answer ON votes.answer_id = answer.id WHERE answer.user_id = '$userid'";
 $query2 = mysql_query($sql2) or die(mysql_error());
 
 echo mysql_num_rows($query2);

Kode 

$sql = 'SELECT answer.user_id, user.navn, v.c FROM answer INNER JOIN user ON answer.user_id = user.id INNER JOIN (SELECT answer_id, COUNT(1) AS c FROM votes GROUP BY answer_id) AS v ON v.answer_id=answer.id';
$query = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($query)){
  print_r($row);
}