How to use pagination in complex query

Your using all single quotes ' change you beginning and ending quotes to double " quotes.
When it sees the next single quote it thinks its the end of that.

PHP Code:

$query = $db->query("SELECT customerName, customercity, customermail, ordertotal,salestotal
FROM onlinecustomers AS c
  INNER JOIN
  orders AS o
  ON c.customerid = o.customerid
  LEFT JOIN
  sales AS s
  ON o.orderId = s.orderId
  WHERE
salestotal > 100
and c.state in ('CA', 'TX')
and c.active = 1
and o.item_no in (1,5,15) "); 


What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )