Datatable where clause?

Datatable where clause?

neozaneoza Posts: 2Questions: 1Answers: 0

$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

  • neozaneoza Posts: 2Questions: 1Answers: 0

    I have been struggling for a while now?

  • allanallan Posts: 63,755Questions: 1Answers: 10,509 Site admin

    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

This discussion has been closed.