Thread: Newest Products
View Single Post
  #5  
Old 01-02-2003, 04:59 AM
 
cyberactive cyberactive is offline
 

Senior Member
  
Join Date: Sep 2002
Location: The Netherlands
Posts: 115
 

Default

The randomise query is
Code:
$query = "SELECT * FROM $sql_tbl[products],$sql_tbl[pricing] WHERE forsale='Y' AND avail>0 AND $sql_tbl[products].productid=$sql_tbl[pricing].productid AND add_date > " . $oldtime . " AND add_date < " . $nowtime . " ORDER BY RAND() LIMIT 5 ";

Just change the number after LIMIT to show more or less products.

Good luck.
__________________
Dennis

Shop @ http://www.cyberlease.nl
Version shop: 3.4.4 (shop is NOT life anymore)
Mods:
- Dutch language
- Changed payment methods and shipping methods
- Package tracking system for Dutch TPGpost.
Reply With Quote