Hi all.
I am working on finishing an oscommerce based site and need some help.
One page is listing in 1 column 6 down, I wish to have a layout of 4
across and 5 down. When there is more then 20 items you can press next
to go to page 2 and so on...
The page I am talking about is here
http://www.philcos.com/catalog/products_new_week.php
Below is the php file. Can anyone help me out here? I went through all
the contributions and there is none like this to use. I also went
through the forum and could not find anything also went through
google!!! Please reply to group or offlist at stevenATciscokid.net
thanks!
----------------
<?php
/*
$Id: products_new.php,v 1.27 2003/06/09 22:35:33 hpdl Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCTS_NEW);
$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_PRODUCTS_NEW));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo
CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER :
HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<link rel="stylesheet" type="text/css" media="print" href="print.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0"
leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table border="0" width="100%" cellspacing="1" cellpadding="0">
<tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0"
width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%"
cellspacing="0" cellpadding="0">
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%',
'10'); ?></td>
</tr>
<?php
$products_new_array = array();
$products_new_query_raw = "select p.products_id, pd.products_name,
p.products_image, p.products_price, p.products_date_added,
p.products_model, m.manufacturers_name from " . TABLE_PRODUCTS . " p
left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id =
m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where
p.products_status = '1' and p.products_id = pd.products_id and
TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) < '" . '7' . "' and
pd.language_id = '" . (int)$languages_id . "' order by pd.products_name
ASC, pd.products_name";
$products_new_split = new splitPageResults($products_new_query_raw,
6);
if (($products_new_split->number_of_rows > 0) &&
((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) {
?>
<tr>
<td><table border="0" width="100%" cellspacing="0"
cellpadding="2">
<tr>
<td class="smallText"><?php echo
$products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW );
?></td>
<td align="right" class="smallText"><?php echo
TEXT_RESULT_PAGE . ' ' .
$products_new_split->display_links(MAX_DISPLAY_PAGE_LINKS,
tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%',
'10'); ?></td>
</tr>
<?php
}
?>
<tr>
<td><table border="0" width="100%" cellspacing="0"
cellpadding="2">
<?php
if ($products_new_split->number_of_rows > 0) {
$products_new_query = tep_db_query($products_new_split->sql_query);
while ($products_new = tep_db_fetch_array($products_new_query)) {
if ($new_price =
tep_get_products_special_price($products_new['products_id'])) {
$products_price = '<s>' .
$currencies->display_price($products_new['products_price'],
tep_get_tax_rate($products_new['products_tax_class_id'])) . '</s> <span
class="productSpecialPrice">' . $currencies->display_price($new_price,
tep_get_tax_rate($products_new['products_tax_class_id'])) . '</span>';
} else {
$products_price =
$currencies->display_price($products_new['products_price'],
tep_get_tax_rate($products_new['products_tax_class_id']));
}
// added for New Product Icon contribution
// convert times to unix timestamp for comparison
// 2592000 = 30 days in the unix timestamp format
if ( ($today_time -
strtotime($products_new['products_date_added']) ) < 2592000) {
$products_new['products_name'] .= ' ' .
tep_image_button('icon_newarrival.gif', TEXT_ICON_NEW_PRODUCT);
}
// end addition New Product Icon contribution
?>
<tr>
<td width="<?php echo SMALL_IMAGE_WIDTH; ?>"
valign="left" class="main"><?php echo '<a href="' .
tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' .
$products_new['products_id']) . '">' . tep_image(DIR_WS_IMAGES .
$products_new['products_image'], $products_new['products_name'],
SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?></td>
<td valign="top"
class="main"><?php echo '<a href="' .
tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' .
$products_new['products_id']) . '"><b>' .
$products_new['products_model'] . ' ' . $products_new['']
..'</b></a><br>' . ' ' . $products_new['manufacturers_name'] . '<br>' .
' ' . $products_price; ?></td>
</tr>
<tr>
<td colspüan="3"><?php echo
tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<?php
}
} else {
?>
<tr>
<td class="main"><?php echo TEXT_NO_NEW_PRODUCTS; ?></td>
</tr>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif',
'100%', '10'); ?></td>
</tr>
<?php
}
?>
</table></td>
</tr>
<?php
if (($products_new_split->number_of_rows > 0) &&
((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) {
?>
<tr>
<td><table border="0" width="100%" cellspacing="0"
cellpadding="2">
<tr>
<td class="smallText"><?php echo
$products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW );
?></td>
<td align="right" class="smallText"><?php echo
TEXT_RESULT_PAGE . ' ' .
$products_new_split->display_links(MAX_DISPLAY_PAGE_LINKS,
tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
</tr>
</table></td>
</tr>
<?php
}
?>
</table></td>
<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0"
width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
</tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
-----------
