<?php
/*
$Id: product_listing_col.php,v 1.1.1.1 2004/03/04 23:41:11 ccwjr Exp $
*/
//declare variables and initialize
// added for CDS CDpath support
$params = isset($_SESSION['CDpath']) ? '&CDpath=' . $_SESSION['CDpath'] : '';
$row = 0;
$column = 0;
$listing_split = new splitPageResults_rspv($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');
if ($listing_split->number_of_rows > 0 && (PREV_NEXT_BAR_LOCATION == '1' || PREV_NEXT_BAR_LOCATION == '3')) {
?>
<!--product-listin-col -->
<?php
}
$list_box_contents = array();
if ($listing_split->number_of_rows > 0) {
$listing_query = tep_db_query($listing_split->sql_query);
$row = 0;
$column = 0;
$no_of_listings = tep_db_num_rows($listing_query);
while ($_listing = tep_db_fetch_array($listing_query)) {
$listing[] = $_listing;
}
echo '<div class="product-listing-module-container">';
for ($x = 0; $x < $no_of_listings; $x++) {
$product_contents = array();
for ($col = 0, $n = sizeof($column_list); $col < $n; $col++) {
$lc_align = '';
$lc_text = '';
// EOF: Lango Added for template MOD
?>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<?php
// BOF: Lango Added for template MOD
if (MAIN_TABLE_BORDER == 'yes') {
table_image_border_top(false, false, $header_text);
}
// EOF: Lango Added for template MOD
?>
<td width="100%" valign="top" align="center"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<!-- wishlist content //start -->
<?php
$wishlist_sql = "select * from " . TABLE_WISHLIST . " where customers_id = '" . $_SESSION['customer_id'] . "' and products_id > 0 order by products_name";
$wishlist_split = new splitPageResults_rspv($wishlist_sql, MAX_DISPLAY_WISHLIST_PRODUCTS);
$wishlist_query = tep_db_query($wishlist_split->sql_query);
$info_box_contents = array();
if (tep_db_num_rows($wishlist_query)) {
$product_ids = '';
while ($wishlist = tep_db_fetch_array($wishlist_query)) {
$product_ids .= $wishlist['products_id'] . ',';
}
$product_ids = substr($product_ids, 0, -1);
$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id in (" . $product_ids . ") and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");
if ($wishlist_split->number_of_rows > 0 && (PREV_NEXT_BAR_LOCATION == '1' || PREV_NEXT_BAR_LOCATION == '3')) {
?>
<div class="product-listing-module-pagination margin-bottom">
<div class="pull-left large-margin-bottom page-results"><?php
echo $wishlist_split->display_count(TEXT_DISPLAY_NUMBER_OF_WISHLIST);
?>