Load a Table based on WHERE SQL command

Load a Table based on WHERE SQL command

tonestones Posts: 7Questions: 0Answers: 0
edited March 2014 in Editor
How can we load a certain table based on a WHERE SQL command, such as SELECT * FROM table WHERE id = 5;

I am using all the latest things; Editor, DataTables 1.10, etc.

I really can't find any place for altering a SELECT command.

Thank you.

Replies

  • asleasle Posts: 96Questions: 28Answers: 0
    The WHERE clause in 1.10 is moved to the file: ssp.class.php on line 174: $where = '';
  • allanallan Posts: 63,530Questions: 1Answers: 10,473 Site admin
    @tones - Are you using the Editor PHP libraries to get your data? If so, use the `where()` API method: https://editor.datatables.net/docs/current/php/class-DataTables.Editor.html

    Allan
This discussion has been closed.