';
$data .= '';
while($row = mysql_fetch_object($result)) {
if($example_id == $row->id) $selected = "selected"; else $selected="";
$data .= "';
$chapter_id = $row->chapter_id;
}
$data .= '';
$data .= ' Download Example';
$elements["examples"] = $data;
/* retreving chapters */
$query = "
SELECT id, name, number, preference_id FROM textbook_companion_chapter
WHERE cloud_chapter_err_status=0 AND preference_id = (
SELECT preference_id FROM textbook_companion_chapter WHERE id = {$chapter_id}
)
ORDER BY number ASC
";
$result = mysql_query($query);
$data = '';
$data .= ' Download Chapter';
$elements["chapters"] = $data;
/* retreving books*/
$query = "
SELECT pre.id, pre.book, author, category FROM textbook_companion_preference pre
WHERE pre.approval_status=1 AND pre.category = (
SELECT category FROM textbook_companion_preference WHERE id = {$preference_id}
) AND cloud_pref_err_status=0 and pre.proposal_id IN (
SELECT id from textbook_companion_proposal where proposal_status=3
) ORDER BY pre.book ASC
";
$result = mysql_query($query);
$data = '';
$data .= ' Download Book';
$elements["books"] = $data;
$elements["category"] = $category_id;
return $elements;
}
?>