Datatable where clause?
Datatable where clause?
$result = $this->datatables->getData('crimereport', array('RefNum','area','type','reportedon','location','status',
'region','channel','capturedby','description','feedback','address','reportedby','mobile','imagelocation','videolocation',
'audiolocation','lat','lot','ar_number','car_reg_num','num_persons','id'), 'id', '','',array('category','Corruption' ));
I have this code but i want to say " pull everything where category IS NOT equal to Corruption " how can i put the Not equal sign on the array?
Answers
I have been struggling for a while now?
What is
datatables->getData
? That isn't a PHP method that I recognise. What is the server-side library you are using? You might be best served by asking that software's author if there is the ability to apply a where condition.Allan