Ante asked 11 years ago
Hello,
i have downloaded free version of pgpgrid. The problem that i have is when i type custom SQL select command
example: "select * from table where somefield='something'"; it works
But when i add ORDER BY command, the table result is empty.
Where is the problem?
Regards,
Ante
1 Answers
Abu Ghufran answered 11 years ago
You need to use following params for order by. It should not be passed as custom sql.
$grid["sortname"] = 'client_id'; // by default sort grid by this field
$grid["sortorder"] = "desc"; // ASC or DESC
….
$g->set_options($grid);
Your Answer
