$row = mysqli_fetch_array($result); ?> <!--Close Header--> <div class="bodyContainer"> <?php include 'resources/includes/leftColumn.html'; ?> <div class="right"> <?php $old = 0; while ($row = mysqli_fetch_array($result)) { $short = substr($row[description], 0, 500) . " ... <a href='ProductPage.php?isbn={$row['ISBN']}'> <br> [More] </a>"; $authors = fListAuthors($link, $row[ISBN]); if ($old !== $row[ISBN]) { echo "<div class='indexBook'>\r\n\t\t\t\t\t\t\t\t\t<div class='title'> <a href='ProductPage.php?isbn={$row['ISBN']}'> {$row['title']} </a> </div>\r\n\t\t\t\t\t\t\t\t\t<div class='author'> {$authors} </div>\r\n\t\t\t\t\t\t\t\t\t<div class='image'> <a href='ProductPage.php?isbn={$row['ISBN']}'> <img src='/sandvig/mis314/assignments/bookstore/bookimages/{$row['ISBN']}.01.MZZZZZZZ.jpg' /> </a> </div> \r\n\t\t\t\t\t\t\t\t\t<div class='detail'> {$short} </div>\r\n\t\t\t\t\t\t\t\t </div>"; } $old = $row[ISBN]; } ?> </div> </div> <!--Open Footer--> <?php include 'resources/includes/footer.html'; ?> <!--Close Footer--> </div>
$result = mysqli_query($link, $sql) or die('SQL syntax error: ' . mysqli_error($link)); $row = mysqli_fetch_array($result); ?> <!--Close Header--> <div class="bodyContainer"> <?php include 'resources/includes/leftColumn.html'; ?> <div class="right"> <div class="productPage"> <?php $authors = fListAuthors($link, $isbn); echo " <div class='title'> {$row['title']} </div> \r\n\t\t\t\t\t\t\t\t <div class='author'>\t{$authors} </div>\r\n\t\t\t\t\t\t\t\t <div class='image'> <img src='/sandvig/mis314/assignments/bookstore/bookimages/{$row['ISBN']}.01.MZZZZZZZ.jpg' /> </div>\r\n\r\n\t\t\t\t\t\t\t\t <div class='detail'>\r\n\t\t\t\t\t\t\t\t \t\t<div class='price'> \${$row['price']} USD </div>\r\n\t\t\t\t\t\t\t\t \t\t<div class='specific'>\r\n\t\t\t\t\t\t\t\t \t\t\t<span style='font-weight: bolder'> ISBN: </span> {$row['ISBN']} <br>\r\n\t\t\t\t\t\t\t\t \t\t\t<span style='font-weight: bolder'> Publisher: </span> {$row['publisher']} <br>\r\n\t\t\t\t\t\t\t\t \t\t\t<span style='font-weight: bolder'> Pages: </span> {$row['pages']} <br>\r\n\t\t\t\t\t\t\t\t \t\t\t<span style='font-weight: bolder'> Edition: </span> {$row['edition']} <br>\r\n\t\t\t\t\t\t\t\t \t\t\t<div class='addtocart'> <a href='shoppingCart.php?addISBN={$row['ISBN']}'> <img src='resources/images/addCart.gif'/> </a></div>\r\n\t\t\t\t\t\t\t\t \t\t</div>\r\n\t\t\t\t\t\t\t\t </div>\r\n\r\n\t\t\t\t\t\t\t\t <div class='desc'> {$row['description']} </div>\r\n\t\t\t\t\t\t\t\t \t\t"; /* $row[price] $row[publisher] $row[pubdate] $row[edition] $row[pages] "; */ ?> </div> </div> </div>