<?php
        $query = "SELECT * FROM products WHERE featured = 1";
                $result=mysql_query($query);
                while($row = mysql_fetch_assoc($result)){
                    $productID=$row['ProductID'];
                     $productName=$row['Product_Name'];
                     $description=$row['Description'];
                     $category=$row['Category'];
                      $sku=$row['SKU'];
                      $stock=$row['Stock'];
                      $cost=$row['Cost'];
                      $price=$row['Price'];
                    $salePrice=$row['Sale_Price'];
                      $productImg=$row['Product_Image'];
	?>
<div id="productsfeat">
        <p id='featimg'><img src="img/<?php echo $productImg;?>" /></p>
        <h3 class="feattxt"><?php echo $productName; ?></h3>
        <p class="feattxt"><?php echo $description; ?></p>
        <p class="feattxt">Regular Price: $<?php echo $price; ?></p>
        <p class="feattxt">Sale Price: $<?php echo $salePrice; ?></p>
        <p class="feattxt">Rated: <img class="ratingstar" src="img/on.png" alt="rating"/><img  class="ratingstar" src="img/on.png" alt="rating"/><img  class="ratingstar" src="img/on.png" alt="rating"/><img  class="ratingstar" src="img/on.png" alt="rating"/><img  class="ratingstar" src="img/on.png" alt="rating"/></p>
      <form method="post" action="cart.php">
      <p>Quantity:
      <select name="quantity">
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
      </select>
      </p>
      <input type="hidden" name="pid" value="<?php echo $productID; ?>" />
      <p class="feattxt"><input type="submit" name="cart_add" value="Add to Cart"/></p>
     </form>    </div>

        <?php  }
        ?>