Jump to content
Sign in to follow this  
silverboy65

how i can turn off random product dislay in " Better Product Display"

Recommended Posts

replace order by rand() with order by p.products_date_added desc

 

 

in the sql.


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites
replace order by rand() with order by p.products_date_added desc

 

 

in the sql.

 

thanks

but i can't find order by rand() in configuration table!

 

edit

i replace that in new_products.php and my index page show this error

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc limit 16' at line 1

select distinct p.products_id, p.products_image, p.products_model, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price, mnf.manufacturers_name, rvw.reviews_rating from products p left join specials s on p.products_id = s.products_id left join manufacturers mnf on p.manufacturers_id = mnf.manufacturers_id left join reviews rvw on p.products_id = rvw.products_id where p.products_status = '1' order by p.products_date_added desc desc limit 16

[TEP STOP]

Edited by silverboy65

Share this post


Link to post
Share on other sites
thanks

but i can't find order by rand() in configuration table!

 

edit

i replace that in new_products.php and my index page show this error

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc limit 16' at line 1

select distinct p.products_id, p.products_image, p.products_model, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price, mnf.manufacturers_name, rvw.reviews_rating from products p left join specials s on p.products_id = s.products_id left join manufacturers mnf on p.manufacturers_id = mnf.manufacturers_id left join reviews rvw on p.products_id = rvw.products_id where p.products_status = '1' order by p.products_date_added desc desc limit 16

[TEP STOP]

 

thanks now work fine

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×