Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Random Products


UncleSteve

Recommended Posts

I'm running the random product contrib. of which I've found some extra code to widen the range of products. All good :)

 

Without confussing me, how can I make the products cycle, rather than 'random cycle' ?

 

What can I do to increase the range of displayed products? - I know how to chnge the quantity (batch) of products displayed on the page (yep thats a mess of a description ;) )

 

Thanks in advance for your help :D

?>
<!-- rnd_products //-->

<?php
  //SET THE QUERYS
$sql_query[0] = 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_ordered asc  limit " . MAX_DISPLAY_NEW_PRODUCTS);

$sql_query[1] = 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_last_modified desc  limit " . MAX_DISPLAY_NEW_PRODUCTS);

$sql_query[2] = 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_quantity  desc  limit " . MAX_DISPLAY_NEW_PRODUCTS);

$sql_query[3] = 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_available desc  limit " . MAX_DISPLAY_NEW_PRODUCTS);

$sql_query[4] = 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 asc  limit " . MAX_DISPLAY_NEW_PRODUCTS);

// uncle steve - start of new code below
$sql_query[5] = 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 asc limit " . MAX_DISPLAY_NEW_PRODUCTS);
	// uncle steve - end of new code above

// get a random number - sam chnged from 4 to 5
$randomize = rand(0, 5);
$rndChooser = $sql_query[$randomize];
?>


<?php

 $info_box_contents = array();
 $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

 new contentBoxHeading($info_box_contents);

  $info_box_contents = array();
  if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) 
  {
	$new_products_query = $rndChooser;
} 
 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;
 $info_box_contents = array();

 while ($new_products = tep_db_fetch_array($new_products_query)) 
 {
	$new_products['products_name'] = tep_get_products_name($new_products['products_id']);
	$info_box_contents[$row][$col] = array('align' => 'center',
										   'params' => 'class="smallText" width="33%" valign="top"',
										   'text' => '<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><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) .'<br>'. '<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_buy_rnd.gif', IMAGE_BUTTON_BUY_NOW) . '</a> ');

	$col ++;
	if ($col > 2) 
	{
		  $col = 0;
		  $row ++;
	}
 }

 new contentBox($info_box_contents);
?>
<!-- rnd_products_eof //-->

____________________________________________________________________

____________________________________________________________________

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...