mySQL, dhtmlx grid, auto column sorting revisited

I corrected a mySQL rendering to autosort along the following lines.

$grid->render_sql(“SELECT * FROM pphone_rad ORDER BY item_id ASC”, “item_id”,“name,pager,office”);

When I do this the sorting is fine, but then clicking on the top header line no longer appears to sort that column alphabetically or reverse alphabetically.  Is this correctable or expected behavior?  Thanks

This is expected behavior, the sorting state from the client side is added to the one, predefined in the SQL, so you have something similar to

ORDER BY item_id ASC, name DESC

Thanks, sort of interesting problem, but I can live with it!