<?php

					$sql = "SELECT * FROM `diploms`";
					$result = mysqli_query($conn, $sql);

					while ($row = mysqli_fetch_assoc($result))
					{
						$topic = $row['topic'];
						$mark = $row['mark'];
						$std_id = $row['id_std'];
						$id_teach = $row['id_teacher'];

						$sql2 = "SELECT * FROM teachers WHERE id_teacher = '$id_teach'";
						$result2 = mysqli_query($conn, $sql2);
						while ($rowp = mysqli_fetch_assoc($result2))
         				{
							$teach=$rowp['fullname'];
						}

						$sql3 = "SELECT * FROM student WHERE id_std = '$std_id'";
						$result3 = mysqli_query($conn, $sql3);
						while ($rowp = mysqli_fetch_assoc($result3))
         				{
							$std_surname=$rowp['surname'];
							$std_name=$rowp['name'];
							$std_otch=$rowp['otchestvo'];
							$std = $std_surname.' '.$std_name.' '.$std_otch;
						}

						echo '<tr>
									<td>'.$topic.'</td>
									<td>'.$mark.'</td>
									<td>'.$std.'</td>
									<td>'.$teach.'</td>
								</tr>';
					}

				?>