Weird in 1.72

[eluser]kodai[/eluser]
[quote author="kodai" date="1259043968"][quote author="aptereket" date="1258777930"]don't use quotes `[/quote]

please copy paste this code and run it

$this->db->orderby("concat(MENU_PATH,if(ID_MENU>999,'',if(ID_MENU>99,'0',if(ID_MENU>9,'00','000'))),ID_MENU)");

then you will know what the problem is [/quote]

Still the same error :

Thanks for your help, but please create the table and try your self :

Code:

CREATE TABLE "tbl_menu" (
  "ID_MENU" int(11) NOT NULL AUTO_INCREMENT,
  "ID_MENU_PARENT" varchar(10) DEFAULT NULL,
  "MENU_NAME" varchar(255) DEFAULT NULL,
  "SEQUENCE_NUMBER" int(11) DEFAULT NULL,
  "MENU_URL" varchar(255) DEFAULT NULL,
  "MENU_ICON" varchar(50) DEFAULT NULL,
  "MENU_ATTRIBUTE" varchar(255) DEFAULT NULL,
  "MENU_TYPE" varchar(20) DEFAULT NULL,
  "STATUS_ACTIVE" int(11) DEFAULT NULL,
  "MENU_PATH" varchar(255) DEFAULT NULL,
  PRIMARY KEY ("ID_MENU")
) AUTO_INCREMENT=1;