Hello,
I have two questions:

1-
I want to include a variable in the sql query.

my query is :
SELECT DRO_District_Site ..............
FROM table
where Date='2012-04-03' group by......;

the date is variable. should i do:

SELECT DRO_District_Site ..............
FROM table
where Date={$REQUEST:var1} group by......;

if yes can I set var1 in an article body where the module is embedded?

or in the module code? if in module code which file exactly?

Regards

Hello,

Request variables are set in an URL (GET variables) or send via a HTML form (POST variables). If you want to use PHP variables, you can modify class.DataTablesDataSqlModel.php file and use an extension like DirectPHP to set variable in an article.

Regards,
ARI Soft

I have a content plug in that allow me to create a HTML/PHP form and send to the same page as GET or POST.

my form field is Date. And I am able to get it in the URL.

now what should I do in the module query to use the Date in the where statement i.e. where Date= $date.

is the following what should I do in class.DataTablesDataSqlModel.php?
$params = array(......
.........
'Dat1' => $Date->get("Date")

then should I use the query as the following:

.............where date={$Date}

We don't know structure of your table and date format which is used in "Date" variable (probably it is not compatible with MySQL date format). Could you provide a link to a page where we can see the module and a form?

Regards,
ARI Soft

My website is not published online yet. The date is a string not a datetime format.

Try to set "SQL -> Debug mode" parameter to "Yes" in module settings to see what error occurs in a SQL query.

Regards,
ARI Soft