These are chat archives for codeigniter-id/codeigniter-id.github.io

23rd
Nov 2017
Netlinqs
@netlinqs
Nov 23 2017 17:25

Hi @GerardBalaoro, thanks for help me. With this query i recover the values from database correctly but this method isn't good because i can't use correctly html.

SELECT * FROM menus ORDER BY CASE WHEN parent = 0 THEN id ELSE parent END, parent, id

Your latest snippet doesn't work :(
Is correct how i have setted my database for categories and subcategories?