WebsiteBaker Support (2.8.x) > Bakery Shop

Sorting products in Bakery shop

(1/1)

svsanchez:
Hello. I need to sort the products displayed on a Bakery catalog by Title in ascending order. How can I do this?

Thank you!

dbs:
Hi, view_overview.php line 63
Original is ORDER BY position, change it to title

--- Code: ---// Query items (for this page)
$query_items = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_items WHERE section_id = '$section_id' AND active = '1' AND title IS NOT NULL ORDER BY title ASC".$limit_sql);

--- End code ---

svsanchez:
Hello dbs, thanks a lot for your help. Your suggestion worked :)

Navigation

[0] Message Index