title: PHP query multiple Tables
body: <p>I'm having trouble getting any information to display from this query. Anyone know where I'm going wrong?</p>
  
  <p>Thank you!  </p>
  
  <pre><code> $query =   "SELECT * ".
              "FROM comments, users ".
              "WHERE comments.user_id = users.user_id ".
              "ORDER BY comments.date DESC ".
              "LIMIT 10";
  
  $result = mysql_query($query) or die(mysql_error());
  
     while ($row = mysql_fetch_array($result)) {
  
  
    echo $row['users.user_id'];
    echo $row['comments.comment'];
  
  
   }
  </code></pre>