Guest Posted October 22, 2006 Posted October 22, 2006 (edited) Hi everyone? Hope everyone is doing as well as possible... I wanted my products below to be able to show up random. Now i located the file that is in control of these products showing up like this... All it does is just post the recent 3 products that i have uploaded? So since im not really smart at php, i figured some of you smart guys out there might be able to look at the code below and say well you can do this. Thank for you help... I hope i gave you all the information that you needed!! Now this is the code for these products, i would like it so that when the page loads it show 3 different products automatically... basically pulls them from my database, blah blah blah.... thanks guys ?> <!-- 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> '; ?> Edited October 22, 2006 by JJ21 Quote
Guest Posted November 3, 2006 Posted November 3, 2006 <?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); } The query pulling the products from the database is sorting by products_date_added change the underlined section to ORDER BY RAND() this should pick random products. Cheers Eric. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.