php - How to fix error Query array failed: 1064

one text

Solution:

Most likely " personal.address_book_id in (".$request['address_book_id'].")" causing issue.

  • If it's array, then you should implode(', ', $request[])
  • If not array, then no need for IN.

Also it's open to SQL injection and if address_book_id is not numeric, then each element must be enclosed in quotes


What class is $this->db? Maybe it has proper query builder?

Source