How do I incorporate "WHERE" statements?

How do I incorporate "WHERE" statements?

rawrzorsrawrzors Posts: 1Questions: 0Answers: 0
edited December 2012 in Editor
Hello, I am new to DataTables (awesome tool so far) and I was wondering what the equivalent to "SELECT * FROM browsers WHERE grade = A"

I am currently looking at the example: htmltable.php

Do I have to do anything in browsers_array.php?

Thank you for your time :)

Replies

  • allanallan Posts: 61,665Questions: 1Answers: 10,096 Site admin
    You'd use the `where` method for the Editor class: http://editor.datatables.net/docs/current/php/class-DataTables.Editor.html#_where .

    [code]
    $editor->where( 'country', 'USA' );
    [/code]

    For example.

    Allan
This discussion has been closed.