Hi. Thanks for the advice. I need a little help here. I've stored the location of a book cover(in jpg format) in another directory. How do I retrieve the location stored in the database and display the book cover to users screen?
Thanks.
Regards,
Major
// below is the source code
<?php
include("./ehexagon/usr.inc");
$bookdetail = $HTTP_GET_VARS['id'];
$query = "select bk.isbn, bk.title, bk.author, bk.price, bk.pages, bk.misc, bk.edition, bk.fk_pubID,
t.title, t.synopsis, t.fk_maincatID, t.fk_subcatID,
i.fk_mediaID, i.url,
md.mediaID, md.media,
cv.coverID, cv.cover,
y.yrID, y.yr,
m.mthID, m.mth
from book_tbl bk,
title_tbl t,
isbn_tbl i,
media_tbl md,
cover_tbl cv,
yr_tbl y, mth_tbl m
where bk.title ='$bookdetail' and
bk.isbn = i.isbn and
i.fk_mediaID = md.mediaID and
i.fk_coverID = cv.coverID and
i.fk_yrID = y.yrID and
i.fk_mthID = m.mthID";
$result = mysql_query($query) or die("Error in query");
while($row=mysql_fetch_object($result)) {
$row->title .'<br>';
// I have problems here. How do I display the
// book jacket using echo statement?
echo '<img src="'.$row->url.'>"';
echo 'ISBN: '.$row->isbn .'<br>';
echo 'Author: '.$row->author .'<br>';
echo 'Media: '.$row->media .', '.$row->cover.', '.$row->pages.' pages.<br>';
echo 'Date published: '.$row->mth.', '.$row->yr.'<br>';
echo 'Price: '.$row->price.'<br>';
echo 'Pages: '.$row->pages .'<br>';
echo 'About the book:'.$row->synopsis .'<br>';
<? }
mysql_close($connection);
?>
