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?