PLEASE HELP!!!!

[feinhorn]

Hi!

 

I bought a OSC template... and in index.php (new_products.php) only shows 4 products, How can I do to show 6 instead of 4?

 

Here is the code of new_products.php... Please give it a try!

 

<?php
/*
 edited - 2005/07/01 13:50

 -----------------------------------------

 $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<?php

 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
 } else {
$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
 }

 $row = 0;
 $col = 0;


 echo '
																					<table border=0  width="462" cellpadding="0" cellspacing="0">
																							<tr><td background="images/m50.jpg" width="1" height="1"></td></tr>
																							<tr>

																								<td background="images/m50.jpg" width="1" height="100%"></td>
																								<td width=462><table cellpadding="0" border=0  cellspacing="0">
																								 <tr>



  ';


 while ($new_products = tep_db_fetch_array($new_products_query)) {
  $new_products['products_name'] = tep_get_products_name($new_products['products_id']);
  $product_query = tep_db_query("select products_description  from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$new_products['products_id'] . "' and language_id = '" . (int)1 . "'");
  $product = tep_db_fetch_array($product_query);
  $new_products['products_description'] = $product['products_description'];
  // get products category
  $categories_query = tep_db_query("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$new_products['products_id'] . "'");
  if (tep_db_num_rows($categories_query) > 0) {
 $categories = tep_db_fetch_array($categories_query);
 $categories_query2 = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$categories['categories_id'] . "'");
 $categories2 = tep_db_fetch_array($categories_query2);
 $category_name = $categories2['categories_name'];
  } else {
 $category_name = '';
  }

  echo '

																								<td valign=top  width="230" >
																									<table cellpadding="0" border=0  cellspacing="0"><tr>
																									<td height="3"></td></tr><tr>
																										<tr>
																											<td valign="top" align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, '') . '</a></td>
																											<td>
																												<table cellpadding="0" border=0  cellspacing="0">
																													<tr><td height=52  valign=top><a class=z href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a></td></tr>
																													<tr><td valign=top><span class="only">NUEVO -</span> <span class="c">'.$currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).'</span></td></tr>
																													<tr><td height="8"></td></tr>
																													<tr>
																														<td>
																															<table cellpadding="0" cellspacing="0">
																																<tr>
																																	<td><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image_button('small_view.gif') . '</a></td>
																																	<td width="6"></td>
																																	<td><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']) . '">' . tep_image_button('button_in_cart.gif').'</a></td>
																																</tr>
																															</table>
																														</td>
																													</tr>
																													<tr><td height="5"></td></tr>
																												</table>
																											</td>
																										</tr>
																									</table>
																								</td>


	';

$col ++;
if ($col > 1) {
  $col = 0;
  $row ++;
  echo '

																											  </tr>
																										<tr><td height="1"></td></tr>
																									</table>
																								</td>
																							</tr>
																						</table>
																					</td>
																				</tr>
																				<tr><td width="461" background="images/m54.jpg"></td></tr>
																				<tr>
																					<td width="462">
																						<table width="462" cellpadding="0" cellspacing="0">

																							<tr><td background="images/m50.jpg" width="1" height="5"></td></tr>
																							<tr>
																								<td background="images/m50.jpg" width="1" height="100%"></td>
																								<td><table cellpadding="0" cellspacing="0"><tr>


	  ';
} else echo '<td background="images/m50.jpg" width="1"></td>';
 }


 echo '

																										</tr>
																										<tr><td height="1"></td></tr>
																									</table>
																								</td>
																							</tr>
																						</table>






  ';


?>
<!-- new_products_eof //-->

 

Thank youuuu!!

 

Fede

[feinhorn]

UPS!!!

 

Just find out that it was at maximum values at admin side....!

 

SORRY!!!

 

Thanks anyway!!