Nathan A

Finally, got this working. Just, had to replace the entire function selectOrderProcess($p,$w){ .... } block with : function selectOrderProcess($p,$w){ /* error_log(debug_print_backtrace()); */ $ed=$_GET["order"];/*if($ed!="")unset($_GET["order"][1]);*/if($_GET["order"])return array(idf_escape(reset($_GET["order"])).($_GET["desc"]?" DESC":""));foreach(($ed!=""?array($w[$ed]):$w)as$v){if($ed!=""||$v["type"]=="PRIMARY"){$Qc=array_filter($v["descs"]);$Gb=false;foreach($v["columns"]as$X){if(preg_match('~date|timestamp~',$p[$X]["type"])){$Gb=true;break;}}$H=array();foreach($v["columns"]as$x=>$X)$H[]=idf_escape($X).(($Qc?$v["descs"][$x]:$Gb)?"...

Finally, got this working. Please see the attachment below, as I am unable to paste the code here, due to some restrictions.

Just to make my requirement more clear : I need some working example code on "How to make the Adminer Editor use the first PRIMARY index for ordering, especially, for both tables, with & without foreign keys. How to use this selectOrderProcess method ( if it is the right method ) ? Thanks. Also, can this method be set as the default for all tables ? If so, how ? I have the serial_number auto-increment column on many tables, for which I would like to order it descendingly ( i.e. latest serial_number...

Hi Jakub, Thanks for the excellent work on Adminer and its Editor ! I need some working example code on "How to make the Adminer Editor use the first PRIMARY index for ordering, for both tables with & without foreign keys. How to use this selectOrderProcess method ? Thanks. Also, can this method be set as the default for all tables ? If so, how ?

Hi Jakub, Thanks for the excellent work on Adminer and its Editor ! I need some working example code on "How to make the Adminer Editor use the first PRIMARY index for ordering, for both tables with & without foreign keys. How to use this selectOrderProcess method ? Thanks. Also, can this method be set as the default for all tables ?

Hi Jakub, Thanks for the excellent work on Adminer and its Editor ! I need some working example code on "How to make the Adminer Editor use the first PRIMARY index for ordering, for both tables with & without foreign keys. How to use this selectOrderProcess method ? Thanks.

Hi Jakub, Thanks for the excellent work on Adminer and its Editor ! I need some working example code on "How to make the Adminer Editor use the first PRIMARY index for ordering, for both tables with & without foreign keys. How to use this selectOrderProcess method ? Thanks.