data as $row)
{
$id = $row['Id'];
$query = "SELECT * FROM files WHERE `BookId` = '$id' AND ({$type})";
if($res = mysql_query_cached($query))
{
$s_title = strip_tags(stripslashes($row['Title']));
$s_authors = strip_tags(stripslashes($row['Authors']));
$s_description = strip_tags(stripslashes($row['Description']));
$s_thumbnail = strip_tags(stripslashes($row['Thumbnail']));
$s_files = "Download as: ";
if(trim($s_description) == "")
{
$s_description = "There is no description for this book.";
}
foreach($res->data as $file_row)
{
$s_formatname = strip_tags(stripslashes($file_row['Format']));
$s_formaturl = strip_tags(stripslashes($file_row['Url']));
$s_files .= "
{$s_formatname}";
}
echo("
![](\"{$s_thumbnail}\")
{$s_description}
");
$found = true;
}
}
}
if($found === false)
{
echo("No books were found that match your query.");
}
?>