featuredprod.ihtml

phpShop是一个基于php的分布式电子商务模块

<?php
// ----------------------------------------------------------------------
// Special Products Manager
// ----------------------------------------------------------------------
// Module designed by Mr PHP
// W: www.mrphp.com.au
// E: [e-mail]
// P: [phone]
// ----------------------------------------------------------------------
// LICENSE
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License (GPL)
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// To read the license please visit http://www.gnu.org/copyleft/gpl.html
// ----------------------------------------------------------------------
require_once('product/lib/ps_product.inc');
$ps_product = new ps_product;

  $db=new ps_DB;
  $q  = "SELECT * FROM product, product_category_xref, category WHERE ";
  $q .= "product_parent_id=''";
  $q .= "AND product.product_id=product_category_xref.product_id ";
  $q .= "AND category.category_id=product_category_xref.category_id ";
  $q .= "AND product.product_publish='Y' ";
  $q .= "AND product.product_special='Y' ";
  $q .= "ORDER BY product_name DESC";
  $db->query($q);
  if($db->num_rows()!=0){ ?>
            <table width="100%" border="0" cellspacing="0" cellpadding="2" class="RecordsTable">
              <tr align="center">
                <td class="RecordsTableHeader">Featured Items</td>
              </tr>
  <?php
  while($db->next_record()){
  ?>
        <tr align="center" valign="top">
          <td><br />
            <?php $ps_product->show_snapshot($db->f("product_sku")); ?>
          </td>
        </tr>
  <?php
  }
?>
  </table>
  <?php
  }
  ?>