|
support
Administrator
4679 Posts |
 Posted - April 12 2006 : 21:10:15
|
Hi there,
You can limit the number of products the script chooses from by just generating random products of the latest 100 products, for example.
To do that, edit the following lines in shoprandomproducts.asp:
line 136:
sqlstr="SELECT catalogid FROM products where hide=0"
replace with:
sqlstr="SELECT TOP 100 catalogid FROM products where hide=0"
Then add another line below line 148:
sqlstr = sqlstr & " ORDER BY catalogid DESC"
So it should look like:
sqlstr = sqlstr & " AND (highercatalogid is null)"
sqlstr = sqlstr & " ORDER BY catalogid DESC"
If you are using MySQL, ignore the first change, and add the following under line 148:
sqlstr = sqlstr & " LIMIT 0,100 ORDER BY catalogid desc"
So it looks like:
sqlstr = sqlstr & " AND (highercatalogid is null)"
sqlstr = sqlstr & " LIMIT 0,100 ORDER BY catalogid desc"
Hope that helps.
Regards,
Joseph
|
Edited by - support on April 12 2006 21:48:23 |
 |
|
All Forums
CINT Function large DB
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
