title: Echo result of two tables
body: <blockquote>
    <p>table course[name,departament,year,id,examinar]
    for example:</p>
    
    <p>music,music Science,first,1,pr.Elias</p>
    
    <p>table grade[studentname,stlastname,departament,,course,yearOfcourse,grade,examinar]
    for example:</p>
    
    <p>roland,doda,music Science,music,first,10,pr.Elias</p>
    
    <p>Now i have the below code</p>
  </blockquote>
  
  <pre><code>$query = "SELECT * FROM course where  year ='first' ";
  $result = mysql_query($query);
  while ($row = mysql_fetch_array($result) ){
      echo "&lt;tr&gt;
          &lt;td&gt;".$row['name']."&lt;/td&gt;
          &lt;td&gt;".$row['departament']."&lt;/td&gt;
          &lt;td&gt;".$row['examinar']."&lt;/td&gt; 
          &lt;/tr&gt;";
  } 
  </code></pre>
  
  <p>This works fine but that i want is into <code>&lt;tr&gt;</code> tags of while loop to echo out the grade from table grade?</p>