Variable inside SQL Select statement.

Beekeeper

How do you insert a query string in the SQL select statement.
I want to get the paramter from the url and want to place it here using variable.
f.paiddate BETWEEN '".$yearURL."-01-01 00:00:00' AND '".$yearURL."-12-31 23:59:59'

URL is something like this
http://example.com?yr=2018

kthorngren

Is this a question regarding Datatables?

Looks like you are using PHP. Maybe this doc will help:
http://php.net/manual/en/reserved.variables.get.php

Kevin

Beekeeper

Yes, sorry to mention the Datatable.
I am using Ajax to call the query and using array to output the SQL $rows.
Using columns:[ ] option to output all the columns into the table.