blob: e13401e51f025a719407985141833b85535596b1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<?php
require_once('db-connect.php');
$book_id = $_POST['book_id'];
// $book_id = $preference_id;
$output = "";
$query = "SELECT * FROM textbook_companion_preference WHERE id = {$book_id}";
$result = mysql_query($query);
$preference =mysql_fetch_array($result);
$query = "SELECT * FROM textbook_companion_proposal WHERE id = {$preference['proposal_id']}";
$result = mysql_query($query);
$proposal = mysql_fetch_array($result);
$output .= "<div class='contributor'><b>Contributor:</b> {$proposal['full_name']} </div>";
$output .= "<div class='teacher'><b>Mentor:</b> {$proposal['faculty']} </div>";
$output .= "<div class='reviewer'><b>Book Reviewer:</b> {$proposal['reviewer']} </div>";
$output .= "<div class='download'><b>College Name:</b> {$proposal['university']} </div>";
echo $output;
?>
|
