Adding / Modifying WHERE clause

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
dlee
Veteran Member
Posts: 137
Joined: 2020-04-14 00:21
Location: South Carolina, USA
Contact:

Adding / Modifying WHERE clause

Post by dlee » 2020-04-22 14:41

I am new to Appgini, love it so far. I need some guidance as to how to either modify or add a WHERE clause to a tables sql statement. So any help with this would be greatly appreciated.

Thanks,
TD

dlee
Veteran Member
Posts: 137
Joined: 2020-04-14 00:21
Location: South Carolina, USA
Contact:

Re: Adding / Modifying WHERE clause

Post by dlee » 2020-04-22 16:09

I found this, $options->QueryWhere = 'WHERE ... and this seems to be the answer.

My final code is:
$options->QueryWhere = 'WHERE `inspections`.`dept_id` = '.$dept_id;

TD

Post Reply