CODEWITHSUNDEEP
phpsql-server
shealtiel
shealtiel

Reputation: 8388

reading data via PDO - the same row is brought twice

I read rows from some mssql table via PHPs PDO.

Some rows, are brought twice, exactly same rows, with exactly the same id values

Any ideas what (the hell) can go on here?

Thank you very much guys

edit: The query that is being run:

select o.accountid, c.contactid, o.opportunityid, o.createdate, o.modifydate, o.createuser, o.modifyuser, o.description, o.projclosedate, o.notes, o.accountmanagerid 
from sysdba.opportunity o 
left join sysdba.opportunity_contact oc on o.opportunityid = oc.opportunityid and oc.salesrole = 'speaker' ";
left join sysdba.contact c on c.contactid = oc.contactid 
where o.status <> 'Inactive' 
order by o.opportunityid asc;

Upvotes: 0

Views: 84

Answers (1)

Joe Phillips
Joe Phillips

Reputation: 51110

I think you need to join your contact table to your opportunity table. It seems that you might not have a 1 to 1 mapping between those tables the way you have it set up. See below:

--This should reference the "o" table but it doesn't.
left join sysdba.contact c on c.contactid = oc.contactid

If that's not the case then you should really be joining around the opportunity_contact table instead (put it as your 'from' table).

Upvotes: 1

Related Questions