tableshow.php

<?php

function show_artists($conn) {
	$sql = "SELECT artist_id, artist_name, label_name FROM artist, record_label WHERE artist.label_id = record_label.label_id";
	$result = $conn->query($sql);

	if ($result->num_rows > 0) {
		echo '<table border>';
		echo '<thead><tr>';
		echo '<th>'."ID".'</th>'.'<th>'."Name".'</th>'.'<th>'."Record Label".'</th>';
		echo '</tr></thead>';
		echo '<tbody>';

		while($row = $result->fetch_assoc()) {
			echo '<tr>';
			echo "<td>" . $row["artist_id"]. "</td>";
			echo "<td>" . $row["artist_name"]. "</td>";
			echo "<td>" . $row["label_name"]. "</td>";
			echo '</tr>';
		}
		
		echo '</tbody>';
		echo '</table>';
	} else {
		echo "0 results";
	}
}

function show_albums($conn) {
	$sql = "SELECT album_id, album_name, genre_name FROM album, genre WHERE artist.genre_id = genre.genre_id";
	$result = $conn->query($sql);

	if ($result->num_rows > 0) {
		echo '<table border>';
		echo '<thead><tr>';
		echo '<th>'."ID".'</th>'.'<th>'."Name".'</th>'.'<th>'."Record Label".'</th>';
		echo '</tr></thead>';
		echo '<tbody>';

		while($row = $result->fetch_assoc()) {
			echo '<tr>';
			echo "<td>" . $row["album_id"]. "</td>";
			echo "<td>" . $row["album_name"]. "</td>";
			echo "<td>" . $row["genre_name"]. "</td>";
			echo '</tr>';
		}
		
		echo '</tbody>';
		echo '</table>';
	} else {
		echo "0 results";
	}
}

?>