well the full query is shown below. the point i was making is that the site has worked perfectly (very many thanks to the ci developers) in all versions of ci upto and including 3.12 which is what i am using now. when i changed to v318 this morning, it crashed and pointed the error at the final question mark in the query. it only works in v318 if i enclose the question mark in quotes. this was the first database call and my code is littered with queries where question marks related to integers are not in quotes so there was no point in going further with the testing. i'd rather stick with v312 than go back and change a mountain of queries. its no big deal, the site works great so if it aint broke dont fix it
$this->db->query('SELECT a.trans_id AS "id" FROM transitems a LEFT JOIN prodpacks.p ON p.c2g=a.prva_id
WHERE (a.transdate >= "?") AND (a.data_type=1) AND (prva_id>0) AND (p.prod_c2g=?) LIMIT 20',array($date,$prodid))
$date is a string, $prodid is an integer.
bill