php - 回显两个表的结果

Question

table course[name,departament,year,id,examinar] for example:

music,music Science,first,1,pr.Elias

table grade[studentname,stlastname,departament,,course,yearOfcourse,grade,examinar] for example:

roland,doda,music Science,music,first,10,pr.Elias

Now i have the below code

$query = "SELECT * FROM course where  year ='first' ";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result) ){
    echo "<tr>
        <td>".$row['name']."</td>
        <td>".$row['departament']."</td>
        <td>".$row['examinar']."</td> 
        </tr>";
} 

这工作正常，但我想要的是 <tr> while 循环的标签从表成绩中回显成绩？

Answer 1

这可能会做你想要的，但我已经做了一些假设进行正确连接所需的列。

我还添加了一些错误检查，这样如果我做出了错误的假设，您就会被告知。

$query = "SELECT c.*,g.grade 
          FROM course c 
              JOIN grade g ON (     g.departament = c.departament
                                AND g.year = c.year
                                AND g.course = c.name                        
                            )
          WHERE c.year ='first' ";

$result = mysql_query($query);
if ( $result === false ) {
    echo mysql_error();
    exit
}

while ($row = mysql_fetch_array($result) ){
    echo "<tr>
        <td>{$row['name']}</td>
        <td>{$row['departament']}</td>
        <td>{$row['examinar']}</td> 
        <td>{$row['grade']}</td> 
        </tr>";
} 

Please dont use the mysql_ database extension, it is deprecated (gone for ever in PHP7) Specially if you are just learning PHP, spend your energies learning the PDO database extensions. Start here its really pretty easy