<?php

include 'private/sql/sql_connect_user.php';

$SELECT = "SELECT * FROM cust_inventory WHERE cust_id='". $_SESSION['cust_id']."' and deleted = 0 and sold = 0";

$result = mysql_query($SELECT);
$count = 5;
$i = 0;
if(mysql_num_rows($result) > 0)
{

    while($row = mysql_fetch_array($result))
    {
        $ean = $row['ean'];
        $photo_title = $row['photo_title'];
        $cust_price = $row['cust_price'];

        include 'private/sql/sql_connect.php';

        $SQL = "SELECT * FROM Book_Info WHERE ISBN13='$ean'";
        $result2 = mysql_query($SQL);
        while($row2 = mysql_fetch_array($result2))
        {
            $Title2 = $row2['Title'];
            $author = $row2['Author'];
            $new = $row2['New'];
            $used = $row2['Used'];


        }


echo	"<table cellpadding='0' cellspacing='0' border='0' class='content_wrapper_b' style='margin-bottom: 10px'>
			<tr><td class='content_wrapper_r'>
				<div class='content_wrapper_t'>
					<div class='content_wrapper_l'>
						<div class='content_wrapper_tl'>
							<div class='content_wrapper_tr'>
								<div class='content_wrapper_bl'>
									<div class='content_wrapper_br'>

										<div class='width_100'>
	<table cellpadding='0' cellspacing='0' border='0'>

		<tr><td class='name name2_padd'><a href='book_reviews.php?ISBN13=$ean'> $Title2 </a></td></tr>
	</table>
	<table cellpadding='0' cellspacing='0' border='0'>
		<tr>
			<td class='pic2_padd'>
  		<table cellpadding='0' cellspacing='0' border='0' align='center' class='pic_b'>

			<tr><td class='pic_r'>
				<div class='pic_t'>
					<div class='pic_l'>
						<div class='pic_tl'>
							<div class='pic_tr'>
								<div class='pic_bl'>
									<div class='pic_br'>
										<div class='width_100'>";

										$filename = "images/books/$photo_title.jpg";
										$size = getimagesize($filename);
										if($size[0]>50){
										$imageDisplay = "images/books/$photo_title.jpg";
										}
										else{
										$imageDisplay = "images/books/sorrysmall.png";
										}



					echo "<a href='book_reviews.php?ISBN13=$ean'><img src='$imageDisplay' border='0' alt='$Title2' title='$Title2' width='145' height='118'></a></div>

						</div>

								</div>
							</div>
						</div>
					</div>
				</div>
			</td></tr>
		</table></td>
			<td style='width:100%;'>
				<table cellpadding='0' cellspacing='0' border='0'>

					<tr><td>Author: $author</td></tr>
					<tr><td>ISBN: $ean</td></tr>
					<tr><td>&nbsp </td></tr>
					<tr><td>
						<table cellpadding='0' cellspacing='0' border='0'>
							<tr><td>New:<br \>Used:<br \>Our Avg:<br /><b>My Price:</b></td>
							<td>$$new<br \>$$used<br \>$<br /><b>$$cust_price</b></td></tr>

						</table>
					</td></tr>
					<tr><td>&nbsp<br /></td></tr>

					</tr>
				</table>
			</td>
		</tr>
		<tr><td>
			<div style='margin-left:30px; 'id='star_rating_system_15'>
						<div class='starClear_15' id='star150' height='15'></div>
					";
						$starrating=8;
						for($count=1;$count<11;$count++){
						if($count>$starrating){
						if($count%2)echo "<div class='starL_15' height='15' id='star15$count'></div>";
						else echo "<div class='starR_15' height='15' id='star15$count'></div>";
						}
						if($count<=$starrating){
						if($count%2)echo "<div class='starL_15_mo' height='15' id='star15$count'></div>";
						else echo "<div class='starR_15_mo' height='15' id='star15$count'></div>";
						}
						}

					echo "<div class='starClear_15' id='star150' height='15'></div>
						</div>

						<div id='preload'>
						<img src='images/star-right-30_mo.png'>
						<img src='images/star-left-30_mo.png'>
						<img src='images/star-right-30.png'>
						<img src='images/star-left-30.png'>

						<img src='images/star-right-15_mo.png'>
						<img src='images/star-left-15_mo.png'>
						<img src='images/star-right-15.png'>
						<img src='images/star-left-15.png'>
						</div>

			</td></tr>





	</table>
	<div>

<table cellpadding='1' cellspacing='0' border='0'>
<tr><td>&nbsp </td><tr>
<tr><td>
			<table border='0' width='100%' cellspacing='0' cellpadding='0'>
				<tr align='center'>
				<td width='25%'><input type='image' src='images/button_remove.gif' border='0' alt='Remove' title=' Remove ' id='remove' onclick='update($ean,1,".$_SESSION['cust_id'].")'></td>
				<td width='25%'><input type='image' src='images/button_review.gif' border='0' alt='Review' title=' Review '></td>
				<td width='25%'><input type='image' src='images/button_edit.gif' border='0' alt='Edit' title=' Edit '></td>
				<td width='25%'><input type='image' src='images/button_sold.gif' border='0' alt='Sold' title=' Sold ' id='remove' onclick='update($ean,4,".$_SESSION['cust_id'].")'></td>
				</tr>

            </table>
</td></tr></table>



	</div>
	</div>
									</div>

								</div>
							</div>
						</div>
					</div>
				</div>
			</td></tr>
		</table>";
		    }

mysql_close($con);