Random Products

[Guest]

Hi everyone, just wanted to see since im not so smart with PHP to see if you guys could change the code below wich controls how my products are posted... Basically all it does is show the three newest products that i have uploaded, i would like it so it chooses 3 products from my database randomly... this is what it looks like

 

 

Now this is the code for the file that controls how these items are selected from my database, and i would like it so that it chooses randomly from my database? Thank guys and gals...

 

?>
<!-- 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 cellspacing=0 cellpadding=0 width=474 align=center>
					  <tr><td height=4 colspan=5></td></tr>
					   <tr><td colspan=5><img src=images/m36.gif width=148 height=15></td></tr>
					   <tr><td height=4 colspan=5></td></tr>
					   <tr><td height=1 width=474 bgcolor=#A90000 colspan=5></td></tr>
					   <tr><td height=16 colspan=5></td></tr>
					   <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'];
  echo '

					   <td width=157 valign=top>
							<table cellspacing=0 cellpadding=0 width=142 align=center>
							 <tr><td height=42 align=center colspan=2><a class=ml2 href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a></td></tr>
							 <tr><td height=8 colspan=2></td></tr>
							 <tr><td colspan=2><img src=images/m40.gif width=142 height=1></td></tr>
							 <tr><td height=4 colspan=2></td></tr>
							 <tr><td width=100 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, 'vspace=5') . '</a></td><td width=42 height=15  valign=bottom class=ch1>'.$currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).'</td></tr>
							 <tr><td height=6 colspan=2></td></tr>
							 <tr><td colspan=2><img src=images/m40.gif width=142 height=1></td></tr>
							 <tr><td height=7 colspan=2></td></tr>
							 <tr><td colspan=2><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image_button('small_view.gif') . '</a>  <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>
							 <tr><td height=3 colspan=2></td></tr>
							</table>
						   </td>



	';

$col ++;
if ($col > 2) {
  $col = 0;
  $row ++;
  echo '
					 </tr>
					 <tr>
	   ';
} else echo '<td width=1 bgcolor=#4C4C4C></td>';
 }


 echo '

					 </tr>
					 <tr><td colspan=2 height=15></td></tr>				
					</table>
   ';


?>

[Guest]

go to Oscommerce Contribution - Randon New Products