Guest Posted February 10, 2003 Posted February 10, 2003 Hi, Some of the products I am entering into the shop come in varying lengths from 36 to 60 inches and every inch inbetween. The problem is that on the product page, the dropdown list containing all the available lengths is not in number order, e.g. it goes 36, 37, 38, 45, 39, 40, 43...... Is there an option somewhere specify that you want the options to be listed in alphanumeric order? If not, any idea where the MySQL query is so that I can specify it at that level? Many thanks.
Guest Posted February 10, 2003 Posted February 10, 2003 I just found a solution. Go to line 118 in products_info.php and add the following code to the end of the database query: ORDER BY pov.products_options_values_name ASC Sorted!!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.