I am running a query via PDO. The query runs fine when I run it directly in phpMyAdmin console, but returns incorrectly when run via PDO. It returns rows as though the NOT EXISTS clause were not there. My query is effectively like this:
SELECT ul.session, CONCAT(u.firstname,' ', u.lastname) AS owner, ...
FROM usagelog ul
INNER JOIN companies c ON ul.company=c.companyid
INNER JOIN users u ON ul.user=u.userid
WHERE (ul.company=:compid OR 0=:compid)
AND ul.created BETWEEN :start AND :end
AND NOT EXISTS(SELECT ss.session FROM seshstatechangelog ss WHERE ss.session=ul.session AND ss.stateto != :state)
ORDER BY ul.created
I have tried with both ?
style binding of variables and :
as you see here.
Has anyone else had this problem?