Sorting products in Bakery shop

[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: [Select]

// 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);


[svsanchez]

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