how to take query attribute?

[Priti_P]

Hello,
I have one query,

$sql_query = db_select('Int_schedule_Table', 'c'); //name given as **c**


$sql_query->fields('c',array('Int_Schedule_Id', 'cand_id', 'Int_Panel_Id', 'Interview_Date', 'Interview_Time','Interview_feedback_status', 'Interview_for_vacancy',  'hr_name', 'Int_Type')); //took fields from C

$sql_query = $sql_query->extend('TableSort')->extend('PagerDefault')->limit(20); // I fired qury here 

$result = $sql_query->orderByHeader($header)->execute(); // after this I have simply applied my logic of displaying fields on $result.

But my question is how can I apply "WHERE" condition on this query?
like WHERE Interview_Date < $today_date.

Please dont tell me to change query stucture since I have used this all over.

[Priti_P]

or is there any way for:
I have an array $rows[], which contains 'Int_Schedule_Id', 'cand_id', 'Int_Panel_Id', 'Interview_Date', 'Interview_Time','Interview_feedback_status', 'Interview_for_vacancy', 'hr_name', 'Int_Type'.

can I again take data of this array in which 'Interview_Date' is greater than $DATE ?

[broj1]

What API do you use?

[Priti_P]

Hello,
Am using this in Drupal.
So any idea for Drupal?

[Priti_P]

see this link
http://drupal.stackexchange.com/questions/5854/how-do-i-use-query-conditions/79970?noredirect=1#comment89927_79970
and tell me how to apply date condition in this.

[Priti_P]

hello guys,
I got solution for this.
I had to just write that query as

$sql_query -> condition('Interview_Date', $today_date , '>=')

where $today_date is a date you want to compare with.