var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Product list sorting in osCommerce
Hi all and happy Friday!! (At least it will be when I get this LAST problem figured out and get paid!).. Anyway here goes.. On the product listing page for osCommerce it list numbers in this order:
How can I modify the SQL so that the numbers are in order?
Anyone know how to do this??
It looks as if you just need to add a "0" to the front to make them 2 digit numbers as well. Not sure if SQL will automatically remove it or not. If you don't need to calculate it, you could change the data type to TEXT. This way, it SHOULDN'T remove the zero for you.
Are those product attributes you have assigned?
I believe it goes by the order you entered them (if memory serves me correct) - Dont think you need to make chanhes to mysql
No they're not attributes. I figured out how to change the SQL to order the attributes correctly. These are products with the width as their title.